Subset tables
A subset table is a static list of the elements of a subset.
The table can have any name. The name is stored in _Subsets.SubsetTable.
This table describes the subset table:
| Column | Type | Description |
|---|---|---|
| MemberName | String(71) | The name of the element. |
| MemberOrder | Integer | The numeric position of the element within the dimension. |
General information
A subset table is the list of elements of one kind of dimension subset only, a static element list. It has the same structure as a member table, without possible attributes or relationships.
A subset table’s name must be stored in the SubsetTable column of _Subsets in the same row as its dimension’s name, which is stored in DimName, and its OLAP name stored in SubsetName.
Subsets of a dimension are loaded automatically with the loading of their dimension. This would be achieved with _Jobs.JobType = 1 and the dimension name in _Jobs.JobObject. Subsets of a dimension can be loaded separately from the loading of their dimension with _Jobs.JobType = 8 and the dimension name in _Jobs.JobObject.
Subset table creation with SQL Server
CREATE TABLE [dbo].[my_subset_table /* Generic name */](
[MemberName] [nvarchar](71) NOT NULL,
[MemberOrder] [int] NULL
)