Define the Calculation Formula (Calculated Cells Wizard)

Analysis Services

Analysis Services

Define the Calculation Formula (Calculated Cells Wizard)

In this step of the wizard, you construct the calculation formula that provides the value for each cell in the calculation subcube. The Next button is enabled only after you enter a calculation formula. When you click Next, the wizard performs a syntax check and proceeds to the next step only if there are no syntax errors. The wizard displays a warning if the syntax check fails.

Options

MDX Expression

Type a Multidimensional Expressions (MDX) expression that evaluates to a single Boolean value.

MDX Builder

Click this to use MDX Builder to construct the expression.