DimensionConnector
Package: model.olap.dimension
Connects a cube to a dimension, establishing the relationship between fact table and dimensional data through foreign key references and enabling dimensional analysis within the cube's multidimensional space.
Extends
- AbstractElement 🔗
Attributes
| Name | Id | Type | Lower | Upper | Default |
|---|---|---|---|---|---|
| usagePrefix | false | String | 0 | 1 | |
| Optional prefix that can be applied to this dimension when used in specific contexts or cubes. The usage prefix allows for dimension name customization and disambiguation when the same dimensional concept is used multiple times within a single analytical context, enabling scenarios like 'Ship Date' and 'Order Date' dimensions that share the same underlying time dimension structure. | |||||
| visible | false | Boolean | 0 | 1 | true |
| Boolean flag controlling whether this dimension appears in client tool dimension lists, XMLA metadata discovery, and cube browsers. When false, the dimension becomes hidden from normal user interfaces but remains accessible through direct MDX references. Deliberately distinct from the inherited CWM ModelElement.visibility, which carries namespace access semantics: visible is a client display hint only, and invisible elements stay fully addressable in MDX. The attribute stays declared per class instead of moving to AbstractElement, where it would bleed onto Catalog, AccessRole and friends. | |||||
| overrideDimensionName | false | String | 0 | 1 | |
| Optional custom name for this dimension as it appears in this specific cube context. When specified, this name overrides the dimension's default name for display purposes in this cube, allowing the same dimension to appear with different names in different cubes for contextual clarity. | |||||
References
| Name | Type | Lower | Upper | Containment |
|---|---|---|---|---|
| foreignKey | Column🔗 | 0 | 1 | false |
| Optional reference to to foreign key column in the fact table that references the primary key of the dimension table, establishing the relational link between fact data and dimensional context for OLAP analysis. Foreign key can be absent if dimension hierarchies and Cube fact table use same table | ||||
| dimension | Dimension🔗 | 1 | 1 | false |
| Reference to the dimension that this connector links to the cube. This establishes which analytical dimension (such as Time, Geography, Product, or Customer) is being connected to the cube's fact data through the foreign key relationship. | ||||
| level | Level🔗 | 0 | 1 | false |
| Optional reference to a specific level within the dimension's hierarchy that should be used as the default level for this dimension connection. When specified, queries against this cube will default to this level rather than the dimension's natural default level. | ||||
| physicalCube | PhysicalCube🔗 | 1 | 1 | false |
| Bidirectional reference to the PhysicalCube that contains this dimension connector, establishing the containment relationship that defines which cube this dimensional connection belongs to and ensuring proper architectural integrity within the OLAP model structure. This required reference creates the fundamental relationship between cubes and their dimensional context, enabling the cube to access and manage its dimensional connections while providing the connector with access to cube-level properties, configuration settings, and metadata that influence dimensional behavior. | ||||
Used by
- WritebackAttribute🔗 → dimensionConnector
- PhysicalCube🔗 → dimensionConnectors
- VirtualCube🔗 → dimensionConnectors