CREATE CELL CALCULATION Statement (MDX)

 

Updated: March 2, 2016

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.

System_CAPS_ICON_note.jpg Note


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

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)
MDX Data Definition Statements (MDX)

Community Additions

ADD
Show: