Creating Session-Scoped Calculated Cells

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.

CREATE CELL CALCULATION Syntax

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 )

ALTER CUBE Syntax

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).

See Also

Concepts

Building Cell Calculations in MDX (MDX)

Help and Information

Getting SQL Server 2005 Assistance