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