Subset table
The
DEPM_MOD_SUBSET table represents an OLAP
hierarchy subset.| Name | Definition |
|---|---|
| Name | nvarchar(100) NOT NULL; PK |
| DimensionID | nvarchar(50) NOT NULL; PK |
| HierarchyName | nvarchar(50) NOT NULL |
| Type | int NOT NULL |
| Definition (can contain Custom Settings) | ntext NULL |
Type indicates whether the subset is static (0) or query-based (1).
Definition is for future enhancements.
The table has these references:
| Source columns | Target table | Target columns |
|---|---|---|
| DimensionID, HierarchyName | _hierarchy | DimensionID, Name |