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:
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.
|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_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:
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.