Cube table
DEPM_MOD_CUBE table represents the OLAP cubes for a model. TABACC and DAC cubes must not be included in this
table . If data tables for DAC cubes are referenced from the DEPM_MOD_DIMENSION table, then they are created when the model is
published.The TABACC cube is a system cube and is provided by the OLAP
server. MDAC cubes are included in the DEPM_MOD_CUBE table
only if editable captions and descriptions, and an association with multiple data cubes are
needed. In other cases, MDAC cubes are created when the model is published from the data table
that is referenced from the DEPM_MOD_MDACTABLE table.
| 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 | int NULL |
| DefaultPermissionValue | int NULL |
ID is unique for the entire database.
Name represents the cube name in OLAP.
IsReference indicates that the cube is not owned by OLAP Modeling but is registered as a placeholder to make the cube reusable
in OLAP 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. Use these values:
- NULL or 0 for data cubes
- 5 for Domain cubes
- 4 for RAC cubes
- 2 for explicitly defined MDAC cubes
DefaultPermissionValue represents the default permission
value for MDAC and RAC cubes. These values are used:
- 0 for the NONE permission
- 1 for the READ permission
- 2 for the WRITE permission