Content objects have a 'base object name'. This base name is used when creating objects (tables/views) in the data warehouse.
Base names can be inherited from parent content, e.g. from Solution to Data Source and then to Data Source Table, but only when the content is created (first time).
Prefixes and postfixes are used to differ different result objects on the same content. E.g. a Dimension has a result view prefixed with vw_, a modification table for manual overrides _MOD, a wide version of P/C Dimension_W etc.
Rules
Type | Content | Base name |
Solution | Solution | |
Module | DW Output, SSAS Database | Module_ |
Module Dimension | Dim_ | |
Module Fact (measure group) | Fact_ | |
Module Fact Source (bi view on each data source table used in measure group) | FactSource_ | |
Dimension | Wide | Dim_ |
Parent/Child | DimPC_ | |
Parent/Child Sub | DimSub_ | |
Time | Time_ | |
Shared Calendar | ShrCalHolidays | |
Data Source | Internal Data Source (DW/Library Source) | Int_ |
Wide Dimension Data Source Table | DimW_ | |
Parent/Child Dimension Data Source Table | DimSrc_ | |
Fact/OB/Other Data Source Table | Fact_ | |
Tag Data Source Table | Tag_ | |
Tables Meta Data Source Table | MetaTbl_ | |
Fields Meta Data Source Table | MetaFld_ | |
Distinct Dimension Key on Data Source Table | Distinct_ | |
System | Shared Solution Distinct Key | DistinctKey_ |
Shared Solution Surrogate Key | SKey_ | |
Placeholder Tag Tags | Tag_ |