Table
Overview
The Table page is used to add or edit a data warehouse table definition in AnalyticsCreator. Use it to define the table metadata, table relationships, inheritance behaviour, columns, calculated columns, scripts, dependencies, measures, physical table definition, identity-column settings, and data warehouse creation action.
Function
Use this page to maintain the technical and business definition of a data warehouse table. The top areas define the table name, schema, table type, friendly name, compression type, description, anonymization check statement, related table links, primary-key settings, and inheritance settings.
The tabbed editor maintains the detailed table structure. The Columns tab defines physical columns and semantic metadata. Other tabs maintain calculated columns, scripts, dependencies, measures, and the physical table definition.
The Identity column area defines identity-column behaviour when an identity key is required. Create in DWH creates the table in the data warehouse. Save stores the table definition. Cancel closes the page without continuing the current edit.
Access
Open this page when you need to add a new table or edit an existing table. Existing tables can be opened from the navigation tree, from the Tables list, or by double-clicking a table object in the diagram.
How to access
Navigation tree
Data warehouse -> Layers -> [layer] -> [schema] -> Tables -> Add table, or Data warehouse -> Layers -> [layer] -> [schema] -> Tables -> [table] -> Edit table.
Toolbar
DWH -> Tables, then use New to add a table or double-click an existing row to edit it.
Diagram
Double-click a table object in the diagram.
Screen overview
The Table page contains several configuration areas. The screen overview is split into the same main areas shown in the screenshot, with the tabbed editor documented by tab.
A. Table details
| ID | Property | Description |
|---|---|---|
| A.1 | Table Name | Technical table name used in the data warehouse model. |
| A.2 | Table Schema | Schema that contains the table. |
| A.3 | Table Type | Table category used by AnalyticsCreator when generating and organising warehouse objects. |
| A.4 | Friendly name | Business-facing table name used in semantic or documentation contexts. |
| A.5 | Compression Type | Compression option assigned to the table. |
| A.6 | Description | Business description or notes for the table. |
| A.7 | Anonymization check statement | Statement used to validate anonymization handling for the table. |
B. Related table and primary-key settings
| ID | Property | Description |
|---|---|---|
| B.1 | Hist of table | Links the table to its historized table when applicable. |
| B.2 | Persist of table | Links the table to its persisted table when applicable. |
| B.3 | Hub of table | Links the table to a Data Vault hub table when applicable. |
| B.4 | Satellite of table | Links the table to a Data Vault satellite table when applicable. |
| B.5 | Link of table | Links the table to a Data Vault link table when applicable. |
| B.6 | Has primary key | Shows whether the table has a primary key. |
| B.7 | PK clustered | Controls whether the primary key is clustered. |
| B.8 | Primary key name | Name used for the primary-key definition. |
C. Inheritance settings
| ID | Property | Description |
|---|---|---|
| C.1 | Inherit FriendlyName | Controls whether the table inherits its friendly name from related metadata. |
| C.2 | Inherit Description | Controls whether the table inherits its description from related metadata. |
| C.3 | Inherit Display Folder | Controls whether the table inherits its display folder from related metadata. |
| C.4 | Inherit all references | Inherits reference metadata where supported. |
| C.5 | Don't inherit PK | Prevents the primary-key definition from being inherited. |
D. Tabbed editor area
Area D contains the table editor tabs. Each tab is documented in a separate table.
D.1 Columns
| ID | Property | Description |
|---|---|---|
| D.1 | Columns | Tab used to maintain the physical and semantic properties of table columns. |
| D.1.1 | Column name | Technical column name in the table. |
| D.1.2 | Data Type | Column data type. |
| D.1.3 | MaxLength | Maximum character length when relevant for the selected data type. |
| D.1.4 | NumPrec | Numeric precision when relevant for the selected data type. |
| D.1.5 | NumScale | Numeric scale when relevant for the selected data type. |
| D.1.6 | Nullable | Shows whether the column allows empty values. |
| D.1.7 | PKOrdinalPos | Position of the column in the primary-key definition. |
| D.1.8 | Default | Default value assigned to the column. |
| D.1.9 | FriendlyName | Business-facing column name. |
| D.1.10 | DisplayFolder | Display folder used for semantic or OLAP output. |
| D.1.11 | Sort by | Column used to define sort order for the selected column. |
| D.1.12 | Referenced column | Referenced column used for relationship metadata. |
| D.1.13 | References | Reference metadata assigned to the column. |
| D.1.14 | Description | Description for the column. |
| D.1.15 | Anonymize | Controls whether anonymization is applied to the column. |
| D.1.16 | Inherit FriendlyName | Controls whether the column inherits its friendly name from related metadata. |
| D.1.17 | Inherit Description | Controls whether the column inherits its description from related metadata. |
| D.1.18 | Collation | Collation setting used by the column when supported. |
D.2 Calculated columns
| ID | Property | Description |
|---|---|---|
| D.2 | Calculated columns | Tab used to maintain calculated column definitions for the table. |
| D.2.1 | Column name | Technical name of the calculated column. |
| D.2.2 | Statement | Expression used to calculate the column value. |
| D.2.3 | Data Type | Data type assigned to the calculated column. |
| D.2.4 | Persisted | Stores the calculated column physically where supported. |
D.3 Scripts
| ID | Property | Description |
|---|---|---|
| D.3 | Scripts | Tab used to maintain SQL that runs before or after table processing. |
| D.3.1 | PreScript | SQL executed before table processing. The script can be viewed as Original, showing the text entered by the user, or Parsed, showing the script after AnalyticsCreator resolves macros and generated expressions. |
| D.3.2 | PostScript | SQL executed after table processing. The script can be viewed as Original, showing the text entered by the user, or Parsed, showing the script after AnalyticsCreator resolves macros and generated expressions. |
D.4 Dependencies
| ID | Property | Description |
|---|---|---|
| D.4 | Dependencies | Tab used to review table dependencies and related object relationships. |
D.5 Measures
| ID | Property | Description |
|---|---|---|
| D.5 | Measures | Tab used to maintain measures exposed from the table. |
| D.5.1 | Measure name | Business name of the measure. |
| D.5.2 | Aggregate | Aggregate behaviour for the measure. |
D.6 Table Definition
| ID | Property | Description |
|---|---|---|
| D.6 | Table Definition | Tab used to review or maintain the physical table definition. |
E. Identity column
| ID | Property | Description |
|---|---|---|
| E.1 | Identity column | Area used to define identity-column settings for the table. |
| E.1.1 | Name | Name of the identity column. |
| E.1.2 | Type | Data type of the identity column. |
| E.1.3 | Seed | Starting value for the identity sequence. |
| E.1.4 | Increment | Increment value for the identity sequence. |
| E.1.5 | PK pos | Primary-key position assigned to the identity column. |
F. Page actions
| ID | Action | Description |
|---|---|---|
| F.1 | Create in DWH | Creates the table in the data warehouse. |
| F.2 | Cancel | Closes the page without continuing the current edit. |
| F.3 | Save | Saves the current table definition and refreshes the relevant navigation or list state. |
