Define the Calculation Condition (Calculated Cells Wizard)

Analysis Services

Analysis Services

Define the Calculation Condition (Calculated Cells Wizard)

In this optional step of the wizard, you can specify a logical Multidimensional Expressions (MDX) expression that limits the scope for a calculated cells formula. The calculated cells formula is applied only to cells of the calculation subcube (defined in the previous step) that meet the condition.

Options

Apply the calculation formula to the entire calculation subcube

Choose this option if you are not adding any calculation condition. The calculated cells formula then applies to all cells in the subcube.

Apply the calculation formula to cells in the calculation subcube that meet the following condition

Choose this option to add a Boolean condition. Choosing this option disables the Next button until after you add an MDX expression. You can either type an expression or use MDX Builder to construct it.

MDX Expression

Type an MDX expression that evaluates to a single Boolean value. The calculated cells formula applies only to those cells for which the expression evaluates to TRUE. The actual cell value is used for any cell for which the expression evaluates to FALSE.

MDX Builder

Click this to use MDX Builder to construct the expression.