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 models| Dimensional-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 |