The dimensional-physical data model-to-Cubing Model transformation
generates objects and properties for Cubing Services model elements
from the dimensional-physical data model.
The following table shows the correspondence between dimensional-physical
data model objects and properties and Cubing Services data model objects
and properties.
Table 1. Mappings from dimensional-physical data
models to Cubing Services modelsDimensional-physical data model object or property |
Cubing Services object or property |
Column |
Attribute |
Column - Name or Label |
|
Column - Documentation |
Description |
Database |
|
Database - Name |
Name |
Diagram |
|
Diagram - Name |
Name |
Dimension table |
Dimension |
Dimension table - Name or label |
|
Dimension table - Documentation |
Comment |
Fact table |
|
Fact table - Name or label |
|
Fact table - Documentation |
Comment |
Hierarchy |
Hierarchy |
Hierarchy - Name |
|
Level |
Level |
Level - Name |
|
Level attribute |
Level attribute |
Level attribute - Name |
Name |
Level attribute - Role |
Role |
Measure column |
Measure |
Measure column - Aggregation function or rule |
Aggregation function |
Measure column - Type- Non-additive
- Additive
- Semi-additive
|
Type- N/A
- Regular aggregate
- Semi-aggregate
|
Relationship |
Dimension Info - Join |
Relationship - Name |
|
Relationship - Cardinality |
Cardinality |
Schema |
|
Schema - Name |
Name |