Caption (clsMemberProperty)
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
The Caption property of an object of ClassType clsMemberProperty contains the name of the column that contains the member property in the members and axis schema rowsets. This is useful for creating language-specific versions of member properties.
Data Type
String
Access
Read/write
Remarks
Individual member properties can have identical Caption values only if they have different values for Language. When a client application requests the contents of a member property, the Analysis server compares the locale ID of the client application to the Language property. The member property with the most appropriate Language value will be sent to the client application.
Two values for the Caption property are noteworthy: MEMBER_CAPTION and DESCRIPTION. The MEMBER_CAPTION schema column should be used to define member captions. Under normal circumstances, a client application should use this schema column for text when displaying members. Similarly, the DESCRIPTION column should be used to define textual member descriptions. By combining these Caption values with specific Language values, the administrator can define localized member captions and descriptions that will be used automatically by any client application.
The following schema column names are defined by OLE DB for OLAP and should not be used as values for the Name or Caption properties of member properties.
- CATALOG_NAME
- SCHEMA_NAME
- CUBE_NAME
- DIMENSION_UNIQUE_NAME
- HIERARCHY_UNIQUE_NAME
- LEVEL_UNIQUE_NAME
- LEVEL_NUMBER
- MEMBER_ORDINAL
- MEMBER_NAME
- MEMBER_UNIQUE_NAME
- MEMBER_TYPE
- MEMBER_GUID
- CHILDREN_CARDINALITY
- PARENT_LEVEL
- PARENT_UNIQUE_NAME
- PARENT_COUNT