MDX Calculated Members - Session-Scoped Calculated Members
APPLIES TO: SQL Server Analysis Services Azure Analysis Services
To create a calculated member that is available throughout a Multidimensional Expressions (MDX) session, you use the CREATE MEMBER statement. A calculated member that is created by using the CREATE MEMBER statement will not be removed until after the MDX session closes.
As discussed in this topic, the syntax of the CREATE MEMBER statement is straightforward and easy to use.
For more information about calculated members, see Building Calculated Members in MDX (MDX).
CREATE MEMBER Syntax
Use the following syntax to add the CREATE MEMBER statement to the MDX statement:
CREATE [SESSION] MEMBER [<cube-name>.]<fully-qualified-member-name> AS <expression> [,<property-definition-list>] <cube name> ::= CURRENTCUBE | <Cube Name> <property-definition-list> ::= <property-definition> | <property-definition>, <property-definition-list> <property-definition> ::= <property-identifier> = <property-value> <property-identifier> ::= VISIBLE | SOLVEORDER | SOLVE_ORDER | FORMAT_STRING | NON_EMPTY_BEHAVIOR <ole db member properties>
In the syntax for the CREATE MEMBER statement, the
fully-qualified-member-name value is the fully qualified name of the calculated member. The fully qualified name includes the dimension or level to which the calculated member is associated. The
expression value returns the value of the calculated member after the expression value has been evaluated,.
CREATE MEMBER Example
The following example uses the CREATE MEMBER statement to create the
LastFourStores calculated member. This calculated member returns the sum of units sold for the last four stores, and will be available throughout the whole session of the cube.
Create Session Member [Store].[Measures].LastFourStores as sum(([Stores].[ByLocation].Lag(3) : [Stores].[ByLocation].NextMember), [Measures].[Units Sold])