Cube table
The
DEPM_MOD_CUBE table represents the OLAP
data cubes for a model. MDAC and DAC cubes are not, and must not be, included in this table .
If data tables for MDAC and DAC cubes are referenced, from the
DEPM_MOD_MDACTABLE and DEPM_MOD_DIMENSION tables
respectively, then they are created when the model is published. | Name | Definition |
|---|---|
| ID | nvarchar(50) NOT NULL; PK |
| Name | nvarchar(50) NOT NULL |
| IsReference | bit NULL |
| ExtendedProperties (can contain custom settings) | ntext NULL |
| ModelName | nvarchar(50) NOT NULL |
ID is unique for the entire Staging database.
Name represents the cube name in OLAP.
IsReference indicates that the cube is not modeled but is a
placeholder to make the cube reusable in modeling.
ExtendedProperties holds additional information about an OLAP cube in the OLAP Extended Properties.xml
format. Examples of the information that is held are the cube caption and its translation,
the cube description and its translation, the measure, and format dimension definition.
ModelName references a model.