次の方法で共有


clsMemberProperty

ms133272.note(ja-jp,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 の参考資料の入手