CREATE CELL CALCULATION Statement (MDX)
Creates a calculation that evaluates a Multidimensional Expressions (MDX) expression over a specified set of tuples within a cube.
Syntax
[WITH <CELL CALCULATION clause> Calculation_Name
[,WITH <CELL CALCULATION clause> Calculation_Name...n]
CREATE CELL CALCULATION CURRENTCUBE | Cube_Name.Calculation_Name
<CELL CALCULATION clause> ::=
FOR Set_Expression AS 'MDX_Expression'
[ [ CONDITION = 'Logical_Expression' ]
| [ DISABLED = { TRUE | FALSE } ]
| [ DESCRIPTION =String ]
| [ CALCULATION_PASS_NUMBER = Integer]
| [ CALCULATION_PASS_DEPTH = Integer]
| [ SOLVE_ORDER = Integer]
| [ Calculation_Name= Scalar_Expression ], ...n]
Arguments
- Cube_Name
A valid string that provides a cube name.
- Calculation_Name
A valid string that provides a cell calculation name.
- Set_Expression
A valid MDX expression that returns a set.
- String
A valid string value.
- MDX_Expression
A valid MDX expression.
- Logical_Expression
A valid MDX logical expression.
- Integer
A valid integer value.
- Calculation_Name
A valid string that provides the name of a cell calculation property.
- Scalar_Expression
A valid MDX scalar expression.
Remarks
By using calculated cells, the client application can specify a rollup value for a particular set of cells, instead of for an entire set of cells as in the case of a custom rollup formula or a calculated member. For example, it is possible to specify that any cell in the set defined by {[Canada],[Time].[2000]} can contain a value that is defined by a formula. Any other cells that are not contained within this set are computed normally.
Note
The Backus-Naur Form (BNF) of {(<comment> | <whitespace> | <newline>)} will be parsed as {} for backwards compatibility.
See Also
Concepts
Creating Session-Scoped Calculated Cells
Creating Query-Scoped Cell Calculations (MDX)
Building Cell Calculations in MDX (MDX)
Using Cell Properties (MDX)
FORMAT_STRING Contents (MDX)
FORE_COLOR and BACK_COLOR Contents (MDX)
Other Resources
MDX Data Definition Statements (MDX)
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
17 July 2006 |
|