Intrinsic Member Properties (MDX)

The following table describes the allowed member properties you can use in CALUMO CMEMBER style formula.

Please see the links below for information about the different supported versions of SQL Server

ACTION_TYPE

A bitmask that indicates the types of actions on the member. This property can have one of the following values:

  • MDACTION_TYPE_URL
  • MDACTION_TYPE_HTML
  • MDACTION_TYPE_STATEMENT
  • MDACTION_TYPE_DATASET
  • MDACTION_TYPE_ROWSET
  • MDACTION_TYPE_COMMANDLINE
  • MDACTION_TYPE_PROPRIETARY
  • MDACTION_TYPE_REPORT
  • MDACTION_TYPE_DRILLTHROUGH

CAPTION

Same as MEMBER_CAPTION.

CHILDREN_CARDINALITY

The number of children that the member has. This can be an estimate, so you should not rely on this to be the exact count. Providers should return the best estimate possible.

CUBE_NAME

The name of the cube to which this member belongs.

CUSTOM_ROLLUP

The custom member expression.

CUSTOM_ROLLUP_PROPERTIES

The custom member properties.

DESCRIPTION

A human-readable description of the member.

DIMENSION_UNIQUE_NAME

The unique name of the dimension to which this member belongs. For providers that generate unique names by qualification, each component of this name is delimited.

HIERARCHY_UNIQUE_NAME

The unique name of the hierarchy. If the member belongs to more than one hierarchy, there is one row for each hierarchy to which the member belongs. For providers that generate unique names by qualification, each component of this name is delimited.

IS_DATAMEMBER

A Boolean that indicates whether the member is a data member.

KEYx

The key for the member, where x is the zero-based ordinal of the key. KEY0 is available for composite and non-composite keys, and KEY1,KEY2, etc are only available for composite keys. Key0, Key1,Key2, etc collectively form the composite key.

LCID x

The translation of the member caption in the locale ID hexadecimal value, where x is the locale ID decimal value (for example, LCID1009 as English-Canada). This is only available if the translation has the caption column bound to the data source.

LEVEL_NUMBER

The distance of the member from the root of the hierarchy. The root level is zero.

LEVEL_UNIQUE_NAME

The unique name of the level to which the member belongs. For providers that generate unique names by qualification, each component of this name is delimited.

MEMBER_CAPTION

A label or caption associated with the member. The caption is primarily for display purposes. If a caption does not exist, the query returns MEMBER_NAME.

MEMBER_KEY

The value of the member key in the original data type. MEMBER_KEY is for backward-compatibility.  MEMBER_KEY has the same value as KEY0 for non-composite keys, and MEMBER_KEY property is null for composite keys.

MEMBER_NAME

The name of the member.

MEMBER_TYPE

The type of the member. This property can have one of the following values:

  • MDMEMBER_TYPE_REGULAR
  • MDMEMBER_TYPE_ALL
  • MDMEMBER_TYPE_FORMULA
  • MDMEMBER_TYPE_MEASURE
  • MDMEMBER_TYPE_UNKNOWN

MDMEMBER_TYPE_FORMULA takes precedence over MDMEMBER_TYPE_MEASURE. Therefore, if there is a formula (calculated) member on the Measures dimension, the MEMBER_TYPE property for the calculated member is MDMEMBER_TYPE_FORMULA.

MEMBER_UNIQUE_NAME

The unique name of the member. For providers that generate unique names by qualification, each component of this name is delimited.

MEMBER_VALUE

The value of the member in the original type.

PARENT_COUNT

The number of parents that this member has.

PARENT_LEVEL

The distance of the member’s parent from the root level of the hierarchy. The root level is zero.

PARENT_UNIQUE_NAME

The unique name of the member’s parent. NULL is returned for any members at the root level. For providers that generate unique names by qualification, each component of this name is delimited.

SKIPPED_LEVELS

The number of skipped levels for the member.

UNARY_OPERATOR

The unary operator for the member.

SQL 2017

https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/mdx/mdx-member-properties-intrinsic-member-properties?view=sql-server-2017

SQL 2016

https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/mdx/mdx-member-properties-intrinsic-member-properties?view=sql-server-2016

SQL 2014

https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/mdx/mdx-member-properties-intrinsic-member-properties?view=sql-server-2014