Modify the SQL views
The DataSelf data warehouse uses SQL views to combine data tables into reporting units, with the following conventions:
The DataSelf OEM version of Tableau's Desktop and Server imports data from a DataSelf SQL data warehouse (or a DataSelf cube database). DataSelf's SQL data warehouses are named DwERP, where Dw signifies Data Warehouse, and ERP is the name of the accounting system or other original data source. (There may be multiple DataSelf data warehouses within one SQL installation.)
For Out of the Box data sources, the _B_ views supply the data source of the same name.
I.e. view _B_SA_Sales supplies the data for the data source template named SA Sales.tds.
The _B_ prefix is for data sources.
The _C_ prefixes are dimensions shared by the _B_ data source views. By sharing the dimensions, uniformity is maintained among the data sources, and a change can be made in one place that will populate indentically across the data sources.
Users with SQL permissions can create new views and new data sources. DataSelf has reserved the _A_ prefix for client use.
Make any desired additions or modifications to the SQL view. You may also need to modify the views that feed into the final _B_ view, and/or add fields and formulas within the ETL's "extract, transform, and load" process. These modifications are beyond the scope of this document. Contact your ERP reseller or DataSelf support technician for help.
Any additions to the _B_DataSourceName view will automatically display in the published data source the next time the extract refreshes, with no further work on your part. Numeric fields will display as Measures, the rest will be attributes. This is a fast way to add fields to a data source, but it doesn't allow you to format the fields or arrange them in hierarchies or folders.
