Objects and properties generated from the dimensional-physical data model-to-Cubing Model transformation

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
  • Name
  • Business Name
Column - Documentation Description
Database
  • Metadata
  • MdSchema
Database - Name Name
Diagram
  • Metadata
  • MdSchema
Diagram - Name Name
Dimension table Dimension
Dimension table - Name or label
  • Name
  • Business Name
Dimension table - Documentation Comment
Fact table
  • CubeModel
  • Fact
Fact table - Name or label
  • Name
  • Business Name
Fact table - Documentation Comment
Hierarchy Hierarchy
Hierarchy - Name
  • Name
  • Business Name
Level Level
Level - Name
  • Name
  • Business 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
  • Name
  • Business Name
Relationship - Cardinality Cardinality
Schema
  • Metadata
  • MdSchema
Schema - Name Name

Feedback