Intrinsic properties are defined for members in all dimensions. In Essbase, the intrinsic MDX member properties defined for all members in an Essbase database outline are MEMBER_NAME, MEMBER_ALIAS, LEVEL_NUMBER, GEN_NUMBER, IS_EXPENSE, COMMENTS, RELATIONAL_DESCENDANTS, and MEMBER_UNIQUE_NAME.
The MEMBER_NAME intrinsic property returns a member name string for each member.
The MEMBER_ALIAS intrinsic property returns a member alias string for each member.
The LEVEL_NUMBER intrinsic property returns the level number of each member.
The GEN_NUMBER intrinsic property returns the generation number of each member.
The IS_EXPENSE intrinsic property returns TRUE if a member has the Expense account type, and FALSE otherwise. Example:
SELECT [Measures].Members DIMENSION PROPERTIES [Measures].[IS_EXPENSE] on columns from Sample.Basic;
The COMMENTS intrinsic property returns a comment string for each member where applicable. Example:
SELECT [Market].Members DIMENSION PROPERTIES [Market].[COMMENTS] on columns from Sample.Basic;
The RELATIONAL_DESCENDANTS intrinsic property retruns TRUE if a member has descendants in a relational database, and FALSE otherwise. This property is only applicable for Hybrid Analysis. Example:
SELECT [Market].Members DIMENSION PROPERTIES [Market].[RELATIONAL_DESCENDANTS] on columns from Sample.Basic;
The MEMBER_UNIQUE_NAME intrinsic property is a member-name property. It returns NULL for unique members, and a system-generated key for duplicate members.