Naming & Metadata
Defines naming, friendly-name, description, and display-folder patterns.
Use this page to find the Naming & Metadata settings, review their defaults, and open the detailed parameter pages.
Available parameters
| Parameter | Technical name | Default value | Purpose |
|---|---|---|---|
| Description Inherit Table Columns | DESCRIPTION_INHERIT_TABLECOLUMNS | 0 | Description inheritance from the table columns to the dependent table columns: 0 - inherit if empty, 1 - always, 2 - never. |
| Description Inherit Tables | DESCRIPTION_INHERIT_TABLES | 0 | Description inheritance from the tables to the dependent tables: 0 - inherit if empty, 1 - always, 2 - never. |
| Description Inherit Trans | DESCRIPTION_INHERIT_TRANS | 0 | Description inheritance from the first transformation table to the transformation: 0 - inherit if empty, 1 - always, 2 - never. |
| Description Inherit Trans Columns | DESCRIPTION_INHERIT_TRANSCOLUMNS | 0 | Description inheritance from the table columns of the data source to the transformation columns: 0 - inherit if empty, 1 - always, 2 - never. |
| Description Inherit Trans Table Columns | DESCRIPTION_INHERIT_TRANSTABLE_COLUMNS | 1 | Description inheritance from the transformation columns to the transtable columns and persisted table columns: 0 - inherit if empty, 1 - always, 2 - never. |
| Description Inherit Trans Tables | DESCRIPTION_INHERIT_TRANSTABLES | 1 | Description inheritance from the transformations to the transtables and persisted tables: 0 - inherit if empty, 1 - always, 2 - never. |
| Description Pattern Calendar ID | DESCRIPTION_PATTERN_CALENDAR_ID | Calendar ID | Autogenerated description of HIST_ID (SATZ_ID) field in calendar dimension. You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID} and {TableID} placeholders. |
| Description Pattern Date From | DESCRIPTION_PATTERN_DATEFROM | {TableName}: Start of validity period | Autogenerated description of DATEFROM (DAT_VON_HIST) field. You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID} and {TableID} placeholders. |
| Description Pattern Date To | DESCRIPTION_PATTERN_DATETO | {TableName}: End of validity period | Autogenerated description of DATETO (DAT_BIS_HIST) field. You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID} and {TableID} placeholders. |
| Description Pattern Hist ID | DESCRIPTION_PATTERN_HIST_ID | {TableName}: Surrogate key | Autogenerated description of HIST_ID (SATZ_ID) field. You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID} and {TableID} placeholders. |
| Description Pattern Snapshot ID | DESCRIPTION_PATTERN_SNAPSHOT_ID | Snapshot ID | Autogenerated description of HIST_ID (SATZ_ID) field in snapshot dimension. You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID} and {TableID} placeholders. |
| Description Pattern Statement | DESCRIPTION_PATTERN_STATEMENT | {Statement} | Autogenerated description in case of using statement as description of transformation fields. You can use {Statement}, {FriendlyName}, {ColumnName}, {ColumnID} and {CR} placeholders. |
| Description Set Special | DESCRIPTION_SET_SPECIAL | 0 | Automatically set description of special columns (SnapshotID, Surrogate key, CalendarID): 0 - Yes if empty, 1 - always, 2 - never. |
| Description Use Statements | DESCRIPTION_USE_STATEMENTS | 0 | Use statement as description: 0 - yes if empty (priority over inherited description), 1 - always, 2 - yes if empty (inherited description has priority), 3 - never. |
| Diagram Name Pattern | DIAGRAM_NAME_PATTERN | {FullFriendlyNameCR} | Object name in diagram. You can use {Name}, {FriendlyName}, {FullFriendlyName}, {FullFriendlyNameCR}, {ID} and {CR} placeholders. |
| Display Folder Inherit Table Columns | DISPLAYFOLDER_INHERIT_TABLECOLUMNS | 0 | OLAP Display Folder inheritance from the table columns to the dependent table columns: 0 - inherit if empty, 1 - always, 2 - never. |
| Display Folder Inherit Trans Columns | DISPLAYFOLDER_INHERIT_TRANSCOLUMNS | 0 | OLAP Display Folder inheritance from the table columns to the transformation columns: 0 - inherit if empty, 1 - always, 2 - never. |
| Display Folder Inherit Trans Table Columns | DISPLAYFOLDER_INHERIT_TRANSTABLE_COLUMNS | 1 | OLAP Display Folder inheritance from the transformation columns to the transtable columns and persisted table columns: 0 - inherit if empty, 1 - always, 2 - never. |
| Friendly Name Inherit Table Columns | FRIENDLYNAME_INHERIT_TABLECOLUMNS | 0 | Friendly name inheritance from the table columns to the dependent table columns: 0 - inherit if empty, 1 - always, 2 - never. |
| Friendly Name Inherit Tables | FRIENDLYNAME_INHERIT_TABLES | 0 | Friendly name inheritance from the tables to the dependent tables: 0 - inherit if empty, 1 - always, 2 - never. |
| Friendly Name Inherit Trans | FRIENDLYNAME_INHERIT_TRANS | 0 | Friendly name inheritance from the first transformation table to the transformation: 0 - inherit if empty, 1 - always, 2 - never. |
| Friendly Name Inherit Trans Columns | FRIENDLYNAME_INHERIT_TRANSCOLUMNS | 0 | Friendly name inheritance from the table columns to the transformation columns: 0 - inherit if empty, 1 - always, 2 - never. |
| Friendly Name Inherit Trans Table Columns | FRIENDLYNAME_INHERIT_TRANSTABLE_COLUMNS | 1 | Friendly name inheritance from the transformation columns to the transtable columns and persisted table columns: 0 - inherit if empty, 1 - always, 2 - never. |
| Friendly Name Inherit Trans Tables | FRIENDLYNAME_INHERIT_TRANSTABLES | 1 | Friendly name inheritance from the transformations to the transtables and persisted tables: 0 - inherit if empty, 1 - always, 2 - never. |
| Friendly Name Pattern Calendar ID | FRIENDLYNAME_PATTERN_CALENDAR_ID | Calendar | Autogenerated friendly name of HIST_ID (SATZ_ID) field in calendar dimension. You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID} and {TableID} placeholders. |
| Friendly Name Pattern Date From | FRIENDLYNAME_PATTERN_DATEFROM | {FriendlyName}_ValidFrom | Autogenerated friendly name of DATEFROM (DAT_VON_HIST) field. You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID} and {TableID} placeholders. |
| Friendly Name Pattern Date To | FRIENDLYNAME_PATTERN_DATETO | {FriendlyName}_ValidTo | Autogenerated friendly name of DATETO (DAT_BIS_HIST) field. You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID} and {TableID} placeholders. |
| Friendly Name Pattern Duplicated Columns | FRIENDLYNAME_PATTERN_DUPLICATED_COLUMNS | {FriendlyName}{NR} | Autogenerated replacement of duplicated friendly names. You can use {FriendlyName}, {ColumnName}, {ColumnID} and {NR} (autoincrement number) placeholders. |
| Friendly Name Pattern Duplicated Tables | FRIENDLYNAME_PATTERN_DUPLICATED_TABLES | {FriendlyName}{NR} | Autogenerated replacement of duplicated friendly names. You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID}, {TableID} and {NR} (autoincrement number) placeholders. |
| Friendly Name Pattern Hist ID | FRIENDLYNAME_PATTERN_HIST_ID | {FriendlyName} | Autogenerated friendly name of HIST_ID (SATZ_ID) field. You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID} and {TableID} placeholders. |
| Friendly Name Pattern Snapshot ID | FRIENDLYNAME_PATTERN_SNAPSHOT_ID | Snapshot | Autogenerated friendly name of HIST_ID (SATZ_ID) field in snapshot dimension . You can use {SchemaName}, {TableName}, {FriendlyName}, {SchemaID} and {TableID} placeholders. |
| Friendly Name Set Special | FRIENDLYNAME_SET_SPECIAL | 0 | Automatically set friendly name of special columns (SnapshotID, Surrogate key, CalendarID): 0 - Yes if empty, 1 - always, 2 - never. |
| Source Reference Description Pattern | SOURCE_REFERENCE_DESCRIPTION_PATTERN | FK_{SourceName1}_{SourceName2} | Autogenerated source reference description. You can use {SourceSchema1}, {SourceName1}, {SourceID1}, {FriendlyName1}, {SourceSchema2}, {SourceName2}, {SourceID2} and {FriendlyName2} placeholders. |
| Source Reference Onecol Description Pattern | SOURCE_REFERENCE_ONECOL_DESCRIPTION_PATTERN | RC_{SourceName1}_{SourceName2}_{ColumnName} | Autogenerated one-column source reference description. You can use {SourceSchema1}, {SourceName1}, {SourceID1}, {FriendlyName1}, {SourceSchema2}, {SourceName2}, {SourceID2}, {FriendlyName2}, {ColumnName}, {ColumnID} and {ColumnFriendlyName} placeholders. |
| Table Reference Description Pattern | TABLE_REFERENCE_DESCRIPTION_PATTERN | FK_{TableName1}_{TableName2} | Autogenerated table reference description. You can use {TableSchema1}, {TableName1}, {TableID1}, {FriendlyName1}, {TableSchema2}, {TableName2}, {TableID2} and {FriendlyName2} placeholders. |
| Table Reference Onecol Description Pattern | TABLE_REFERENCE_ONECOL_DESCRIPTION_PATTERN | RC_{TableName1}_{TableName2}_{ColumnName} | Autogenerated one-column table reference description. You can use {TableSchema1}, {TableName1}, {TableID1}, {FriendlyName1}, {TableSchema2}, {TableName2}, {TableID2}, {FriendlyName2}, {ColumnName}, {ColumnID} and {ColumnFriendlyName} placeholders. |
