Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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.

Note Note

In Microsoft SQL Server, member properties are know as attribute relationships. For more information, see Attribute Relationships.

Member properties are either intrinsic or custom:

Intrinsic member properties

All members support intrinsic member properties, such as the formatted value of a member, while dimensions and levels supply additional intrinsic dimension and level member properties, such as the ID of a member.

For more information, see Intrinsic Member Properties (MDX).

User-defined member properties

Members often have additional properties associated with them. For example, the Products level may offer the SKU, SRP, Weight, and Volume properties for each product. These properties are not members, but contain additional information about members at the Products level.

For more information, see User-Defined Member Properties (MDX).

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft