Cube rule table
The
DEPM_MOD_CUBERULE table represents an OLAP cube rule.
| Name | Definition |
|---|---|
| ID | nvarchar(50) NOT NULL; PK |
| CubeID | nvarchar(50) NOT NULL; PK |
| ShortDescription | nvarchar(150) NOT NULL |
| Description | nvarchar(150) NULL |
| ParentGroupID | nvarchar(50) NULL |
| ParentGroupCubeID | nvarchar(50) NULL |
| Target (can contain Custom Settings) | ntext NULL |
| Formula (can contain Custom Settings) | ntext NULL |
| AffectedCells | nchar(1) NOT NULL |
| Enabled (can contain Custom Settings) | bit NULL |
| Order | int NOT NULL; unique key |
These values for AffectedCells indicate which cells are affected by the rule:
- A: All cells
- B: Base cells
- C: Consolidated cells
The table has these references:
| Source columns | Target table | Target columns |
|---|---|---|
| CubeID | _cube | ID |
| ParentGroupCubeID, ParentGroupID | _cubeRuleGroup | CubeID, ID |