Analysis Services
Define the Calculation Subcube (Calculated Cells Wizard)
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.
Options
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. |