Calculated Cells Wizard

Analysis Services

Analysis Services

Calculated Cells Wizard

Use this wizard to create calculated cells. Calculated cells enable you to use a Multidimensional Expressions (MDX) expression to override values for cells in a specific area of a cube.

The Calculated Cells Wizard appears when you perform any of the following actions:

  • In the Cube Editor or Virtual Cube Editor tree pane, right-click the Calculated Cells folder, and then click New Calculated Cells.

  • In the Cube Editor or Virtual Cube Editor, on the Insert menu, click Calculated Cells.

  • Right-click an existing calculated cells definition in the Cube Editor or Virtual Cube Editor, and then click New Calculated Cells or Edit.

The Calculated Cells Wizard has the following steps:

  • Define the calculation subcube.

  • Define the calculation condition.

  • Define the calculation formula.

  • Name and save the calculated cells definition.

See Also

Calculated Cells