clsMemberProperty

ms133272.note(zh-tw,SQL.90).gif附註:
  下一版的 Microsoft SQL Server 將不再提供此功能。請勿在新的開發工作中使用此功能,並且儘速修改使用此功能的應用程式。

The member property object defines a property for a level member. Like level members, these properties are read from the dimension table. A level can have any number of member properties. An object of ClassType clsMemberProperty provides collections and properties through its own internal interface. There are no methods associated with this object class. clsMemberProperty objects are contained in a parent level object's MemberProperties collection.

備註

Access to the properties of an object of ClassType clsMemberProperty depends on the context in which it is used. clsMemberProperty objects are created and managed in the context of a database level and have read/write access. Cube and partition levels inherit member properties from the database level. Member properties accessed through cube and partition level objects are read-only.

Member properties are versatile objects that can be used to facilitate a number of different tasks. One task, for example, is that of sorting the members of a level by a particular attribute. For example, consider the States level of the Geography dimension. A member property can be defined that refers to the population of the state. Client applications can then sort on this population property.

請參閱

參考

clsAggregationLevel
clsDatabaseLevel
clsCubeLevel
clsPartitionLevel
Collections, clsMemberProperty
Properties, clsMemberProperty

說明及資訊

取得 SQL Server 2005 協助