Export (0) Print
Expand All

CREATE CELL CALCULATION Statement (MDX)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Creates a calculation that evaluates a Multidimensional Expressions (MDX) expression over a specified set of tuples within a cube.

[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]

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.

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 Note

The Backus-Naur Form (BNF) of {*(<comment> | <whitespace> | <newline>)} will be parsed as {*} for backwards compatibility.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft