In this step of the wizard, you define the calculation subcube. The subcube defines the scope of the calculation formula. To restrict the subcube, select a dimension from the Dimensions box and a member selection operator from the Members Set box.
Dimensions
Select each dimension for which you want to specify a Members Set.
Members Set
After you select a dimension, select the members set to which the formula applies. You can press DELETE while a dimension is selected to reset it to All members. The available options depend on the type of dimension selected.
The following table lists options that apply to the Measures dimension.
| Select | To |
|---|---|
| All members | Select all members in a dimension. This choice results in an empty set that is interpreted as all members, excluding calculated members, of the Measures dimension. This is the default for the Measures dimension. |
| A single measure | Select a single measure from the list displayed. |
| Custom MDX expression | Build a Multidimensional Expressions (MDX) expression either by typing it under MDX Expression or by clicking MDX Builder to use MDX Builder. |
The following table contains options that apply to all other dimensions.
| Select | To |
|---|---|
| All members | Select all members in a dimension. This choice results in an empty set that is interpreted as all members, excluding calculated members, of the dimension. This is the default for each dimension. |
| A single member | Select a single member from the list displayed. |
| A single level | Select a single level in the dimension from the list displayed. |
| Descendants of a member | Display a tree view of the dimension. Expand the tree and select a single member. |
| Descendants of a member at a level | Select a level for a member. Expand the tree under Member to select a member, and then under Level select a single level. |
| Custom MDX expression | Build a MDX expression either by typing it under MDX Expression or by clicking MDX Builder to use MDX Builder. |