_Subsets
The _Subsets table describes the subsets of the dimensions. A subset is an ordered set of elements contained within the set of elements of a dimension. Subsets can be loaded with the dimension.
This table describes _Subsets:
| Column | Type | Description |
|---|---|---|
| DimName | String(50) | The name of the dimension. |
| SubsetName | String(50) | The name of the subset of the dimension. |
| SubsetKind | Integer | The type of the
subset. Enumerator. The values are: 1 = Element List 2 = Attribute Query (Not implemented) 3 = Data Query (Not implemented) |
| SubsetCategory | Integer | The category of
subset. Enumerator. The values are:
|
| SubsetTable | Text | The name of the relational table from which the subset is sourced. This can be a sub-query. |
| Comment | Text | User defined comment. |
General information
The DimName column is linked to DimensionName in the _Dimensions table.
A dimension can have any number of subsets. The subsets are loaded when a dimension is loaded (_Jobs.JobType = 1) or when the subsets are loaded for an existing (already loaded) dimension (_Jobs.JobType = 8).