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 |
| CubeType | 5 for Domain cubes, otherwise NULL or 0 |
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.
CubeType represents the cube type in OLAP.