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.