Dimension table
Overview
Dimension table is a table type that stores descriptive attributes used to analyze facts.
Function
Use this type when a data mart requires reusable descriptive context such as customer, product, or date. Selecting it participates as a dimension object in analytical and model structures.
When to use
Choose Dimension table when a data mart requires reusable descriptive context such as customer, product, or date.
Behavior in AnalyticsCreator
| Area | Behavior |
|---|---|
| Configuration | Configure dimension keys, attributes, friendly names, hierarchies, and semantic properties. |
| Processing | Warehouse or transformation processes populate descriptive dimension rows. |
| Output | The table provides attributes and hierarchies used to filter and group measures. |
Type-specific properties
| Property | Description |
|---|---|
| Dimension key | Key used by fact relationships. |
| Attributes | Descriptive columns exposed for analysis. |
| Hierarchies | Ordered levels used for navigation. |
| Historization | Optional treatment of changing dimension attributes. |
Compatibility and limitations
Keys and attributes must remain consistent with related fact data.
Relationships
| Related entity | Relationship |
|---|---|
| Table | The table type defines the purpose and behavior of the table entity. |
| Schema | The schema type and warehouse architecture influence which table types are normally used. |
| Package | Import, historization, and persisting packages can populate specific table types. |
