Object Naming

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

  • Base names are set from old model during upgrade from 52x solutions. The base name is prefixed with SolutionID.
  • On paste/new from template, you can select weather to inherit or use new naming model (or select your own name).
  • When you add a new empty content, base names from parents are inherited and new naming model used. Set the base name on parents before adding new content.
  • Existing base names are not changed unless you override them manually in the content property dialog.

Base names for new objects

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_

Content that do not have or use base names:

  • AccessControl
  • DataFlow
  • DataFlowFolder
  • DimManagementFolder
  • DimTreeFolder
  • DistinctKeyFolder
  • DWOutputFolder
  • LocalTemplates
  • ModuleSubGroup
  • NameDefinitions
  • OlapDbFolder
  • PlaceholderTagTableFolder
  • RemoteTemplates
  • ResourceLibrary
  • ScheduleManagement
  • SolutionConfigFolder
  • SolutionPartitions
  • SolutionSettings
  • SurrogateKeyFolder
  • TemplateFolder
  • TimeDimFolder
  • UserBookmark
  • UserFolder