Export (0) Print
Expand All

Creating Session-Scoped Calculated Cells

Important note Important

This syntax has been deprecated. You should use MDX assignments should instead. For more information on assignments, see The Basic MDX Script (MDX).

To create calculated cells that are available to all queries in the same session, you can use either the CREATE CELL CALCULATION statement or the ALTER CUBE statement. Both statements have the same result.

Important note Important

This syntax has been deprecated. You should use MDX assignments should instead. For more information on assignments, see The Basic MDX Script (MDX).

Use the following syntax to use the CREATE CELL CALCULATION statement to define a session-scoped calculated cell:

CREATE CELL CALCULATION Cube_Expression.<CREATE CELL CALCULATION body clause>
  
<CREATE CELL CALCULATION body clause> ::=CellCalc_Identifier FOR String_Expression AS 'MDX_Expression' 
   [ <CREATE CELL CALCULATION property clause> [ , <CREATE CELL CALCULATION property clause> ... ] ]
  
<CREATE CELL CALCULATION property clause> ::=
   ( CONDITION = 'Logical_Expression' ) | 
   ( DISABLED = { TRUE | FALSE } ) | 
   ( DESCRIPTION =String_Expression ) | 
   ( CALCULATION_PASS_NUMBER = Integer_Expression ) | 
   ( CALCULATION_PASS_DEPTH = Integer_Expression ) | 
   ( SOLVE_ORDER = Integer_Expression ) | 
   ( FORMAT_STRING = String_Expression ) | 
   ( CellProperty_Identifier = Scalar_Expression )

Important note Important

This syntax has been deprecated. You should use MDX assignments should instead. For more information on assignments, see The Basic MDX Script (MDX).

Use the following syntax to use the ALTER CUBE statement to define a session-scoped calculated cell:

ALTER CUBE Cube_Identifier CREATE CELL CALCULATION
FOR String_Expression AS 'MDX_Expression' 
   [ <CREATE CELL CALCULATION property clause> [ , <CREATE CELL CALCULATION property clause> ... ] ]
  
<CREATE CELL CALCULATION property clause> ::=
   ( CONDITION = 'Logical_Expression' ) | 
   ( DISABLED = { TRUE | FALSE } ) | 
   ( DESCRIPTION =String_Expression ) | 
   ( CALCULATION_PASS_NUMBER = Integer_Expression ) | 
   ( CALCULATION_PASS_DEPTH = Integer_Expression ) | 
   ( SOLVE_ORDER = Integer_Expression ) | 
   ( FORMAT_STRING = String_Expression ) | 
   ( CellProperty_Identifier = Scalar_Expression )

The String_Expression value contains a list of orthogonal, single-dimensional MDX set expressions, each of which must resolve to one of the categories of sets that are listed in the following table.

Category

Description

Empty set

An MDX set expression that resolves into an empty set. In this case, the scope of the calculated cell is the whole cube.

Single member set

An MDX set expression that resolves into a single member.

Set of level members

An MDX set expression that resolves into the members of a single level. An example of this is the Level_Expression.Members MDX function. To include calculated members, use the Level_Expression.AllMembers MDX function.

For more information, see AllMembers (MDX).

Set of descendants

An MDX set expression that resolves into the descendants of a specified member. An example of this is the Descendants(Member_Expression, Level_Expression, Desc_Flag) MDX function.

For more information, see Descendants (MDX).

Community Additions

ADD
Show:
© 2015 Microsoft