Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

Intrinsic Member Properties

All members support a list of intrinsic member properties as well, displayed in the following table. Intrinsic member properties cannot be requested for a specific dimension or level; they apply to all members of an axis dimension in a Multidimensional Expressions (MDX) query. Specifying, for example, the following statement in an MDX query:

PROPERTIES DESCRIPTION

returns the description of each member in the axis dimension.

The following table lists the intrinsic member properties supported by Microsoft® SQL Server™ 2000 Analysis Services.

Property Description
CALCULATION_PASS_DEPTH For calculated cells only. The pass depth for the calculation formula, this property determines how many passes are needed to resolve the calculation formula.
CALCULATION_PASS_NUMBER For calculated cells only. The pass number for the calculation formula, this property determines on which pass the calculation formula will begin evaluation and end calculation. The default for this property is 1; its maximum value is 65,535.
CATALOG_NAME The name of the catalog to which this member belongs.
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.
CONDITION For calculated cells only. The calculation condition of the calculated cells. This property receives an MDX logical expression, which is evaluated on each cell in the calculation subcube. If it returns True, the calculation formula is applied and the cell returns the resulting value. If it returns False, the cell returns the original cell value. If not specified, CONDITION defaults to True (in other words, the calculation formula applies to all cells in the calculation subcube.)
CUBE_NAME The name of the cube to which this member belongs.
DESCRIPTION A human-readable description of the member or calculated cells definition.
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.
DISABLED For calculated cells only. A Boolean property that indicates whether or not the calculated cells are disabled. DISABLED defaults to False.
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 it belongs. For providers that generate unique names by qualification, each component of this name is delimited.
LEVEL_NUMBER The distance of the member from the root of the hierarchy. The root level is zero.
LEVEL_UNIQUE_NAME 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. It is used primarily for display purposes. If a caption does not exist, MEMBER_NAME is returned.
MEMBER_GUID The member GUID.
MEMBER_NAME The name of the member.
MEMBER_ORDINAL The ordinal number of the member. This is the sort rank of the member when members of this dimension are sorted in their natural sort order. If providers do not have the concept of natural ordering, this should be the rank when sorted by MEMBER_NAME.
MEMBER_TYPE The type of the member. It can be 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, it is listed as 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.
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.
SCHEMA_NAME The name of the schema to which this member belongs.

Columns in the MEMBERS schema rowset support the intrinsic member properties. Other intrinsic member properties can be supported, depending upon the provider. However, all providers must support the intrinsic member properties listed here to be compliant with the OLAP section of the OLE DB specification dated March 1999 (2.6).

Intrinsic member properties are used without additional specification of any sort, as intrinsic member properties apply to all members. The following syntax example demonstrates usage:

PROPERTIES «Property»

Important  Because intrinsic member properties cannot be qualified by the dimension or level name, a consumer cannot choose different intrinsic member properties for different dimensions (or levels) on an axis. For example, if the ROWS axis has Geography and SalesRep dimensions, the consumer cannot choose the MEMBER_CAPTION intrinsic member property for the Geography dimension or the MEMBER_UNIQUE_NAME intrinsic member property for the SalesRep dimension. The consumer must choose the same intrinsic member property (or properties) for all dimensions on an axis.