Members of a dynamic subset change when members are added or removed from the dimension.
A dynamic subset uses an expression to select the members for the subset. When new members are added to the dimension and the member falls into the category the expression defines, the new members are added to the subset without further editing. The expressions are edited in an MDX editor.
You can change a subset from a static to a dynamic subset and back again by checking the Dynamic subset checkbox. A dynamic subset must contain an expression. A static subset can also be defined with the expression editor, and then saved as a static list.
You can edit the expression directly and you can cut and paste MDX expressions from other sources.
Procedure
- Right-click the dimension and then select New > Subset.
- Type a name for the new subset and click OK.
-
Click on the name of the new subset in the Model Design pane to display the Properties page for the subset.
- Click the edit button in the Expression Property.
The MDX expression editor opens.
-
Select the Dynamic check box. If the Dynamic check box is not selected, the subset will be a static subset and will not reflect subsequent changes made to the members lists.
-
You can type, or copy and paste an MDX expression directly into the Expression box. Or you can select an option from the Subset Basis selection as a starting point for the expression:
| Option |
Description |
|---|
| Level(n) |
The levels that are available for members. |
| All Members |
All members of the dimension. |
| Current Members |
The current members of the subset. |
| Selected Members |
The selection from the list of members in the Name column. |
- Select the sort type from the Sort selection, Ascending, Descending or Hierarchy.
- Click OK to apply the changes and
close the editor, click Apply to apply the
changes and keep the editor open.