Cube table
The
DEPM_MOD_CUBE
table holds the OLAP cubes
for a model.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.