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