With calculated cells, you can define a
For example, you can create a calculated cells definition that provides forecasting values for the next year from a calculation based on the actual values of the current year, but only for specific clients and products. Unlike calculated members, custom members, or custom rollups, this functionality can affect specific cells of a cube, instead of an entire member; a calculated cells definition can be created for only a single cell in an entire cube.
As with calculated members, the definitions for calculated cells are stored. The values for calculated cells are evaluated only when the cube is queried by a client application. Unlike calculated members, however, the cells retain their original underlying data. Thus, calculated cells can be added to a cube without affecting the underlying data, and calculated cells can be removed from the cube without invalidating the cube. Calculated cells are not evaluated when processing a regular or virtual cube; the cube is processed as if the calculated cells definitions do not exist.
With the introduction of
You can create calculated cells in regular or virtual cubes. For more information about creating calculated cells, see Creating Calculated Cells in Regular Cubes and Creating Calculated Cells in Virtual Cubes.
To create a calculated cells definition, use the Calculated Cells Wizard. It enables you to specify the following options for the calculated cells:
Select the members from each dimension in the cube to define the
If members are not specified from any of the dimensions of the regular or virtual cube, the calculation subcube is defined as the entire regular or virtual cube.
Define an MDX logical expression (an expression that evaluates to either True or False) that will be applied to each cell in the calculation subcube. If the
If no calculation condition is specified, the calculation formula will apply to all cells in the calculation subcube.
Define an MDX expression that will supply the value of each cell in the calculation subcube, subject to the calculation condition. The
After they have been created, calculated cells can also be edited in Cube Editor (for regular cubes) or Virtual Cube Editor (for virtual cubes).
To edit a calculated cells definition in Cube Editor
To edit a calculated cells definition in Virtual Cube Editor