Using Member Properties (MDX)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Member properties cover the basic information about each member in each tuple. This basic information includes the member name, parent level, the number of children, and so on. Member properties are available for all members at a given level. In terms of organization, member properties are treated as dimensionally organized data, stored on a single dimension.
In Microsoft SQL Server, member properties are know as attribute relationships. For more information, see Attribute Relationships.
Member properties are either intrinsic or custom:
Both intrinsic and user-defined member properties can be retrieved through the use of the PROPERTIES keyword or the Properties function.
The PROPERTIES keyword specifies the member properties that are to be used for a given axis dimension. The PROPERTIES keyword is buried within the <axis specification> clause of the MDX SELECT statement:
SELECT [<axis_specification> [, <axis_specification>...]] FROM [<cube_specification>] [WHERE [<slicer_specification>]]
The <axis_specification> clause includes an optional <dim_props> clause, as shown in the following syntax:
<axis_specification> ::= <set> [<dim_props>] ON <axis_name>
For more information about the <set> and <axis_name> values, see Specifying the Contents of a Query Axis (MDX).
The <dim_props> clause lets you query dimension, level, and member properties using the PROPERTIES keyword. The following syntax shows the formatting of the <dim_props> clause:
<dim_props> ::= [DIMENSION] PROPERTIES <property> [,<property>...]
The breakdown of the <property> syntax varies depending on the property that you are querying:
Context sensitive intrinsic member properties must be preceded with the name of the dimension or level. However, non-context sensitive intrinsic member properties cannot be qualified by the dimension or level name. For more information about how to use the PROPERTIES keyword with intrinsic member properties, see Intrinsic Member Properties (MDX).
User-defined member properties should be preceded by the name of the level in which they reside. For more information about how to use the PROPERTIES keyword with user-defined member properties, see User-Defined Member Properties (MDX).