A reference to a pivot variable that contains a member expression. To refer to a pivot variable, use the following syntax:
Where variablename is the logical variable name. Do not enclose this expression with square brackets. This syntax is not case-sensitive; nor is the pivot variable name.
For information on defining pivot variables, see Defining and Using Pivot Variables in Using the Analyzer.
For example, the following member expressions are all equivalent:
[gend].[h1].[gender].Female
[gend].female
gend.H1.gender.female
gend.h1.FEMALE
gend.female
Calculated Members
Members can be defined within the cube definition, as part of the definition of a level. You can also create calculated members, which are typically based on other members. You can define calculated members in two ways:
-
Within the WITH clause of a query. The member is available within the rest of the query, but is not available in other queries.
-
Within the CREATE MEMBER statement. The member is available within the rest of the session (for example, within the rest of the session in the MDX shell).
Uses
You can use member expressions in the following ways: