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.