AreMemberKeysUnique
.gif "ms135637.note(ja-jp,SQL.90).gif") メモ : |
|---|
| この機能は、Microsoft SQL Server の次のバージョンで削除されます。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションはできるだけ早く修正してください。 |
The AreMemberKeysUnique property of the Dimension interface indicates whether member keys are unique throughout the dimension and whether these members can be referred to by their keys.
Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension
Data Type
Boolean
Access
Access depends on the value of the ClassType property of the object.
| Class type | Access |
|---|---|
clsDatabaseDimension |
R/W |
clsCubeDimension |
R |
clsPartitionDimension |
R |
clsAggregationDimension |
R |
解説
This property can be set to True only if the AreMemberKeysUnique property is set to True for all of the levels in the dimension.
This property can be used in two situations:
- When you know that the position of a member (and that of the children of the member) may move within a dimension hierarchy. You can make the method for generating unique names more consistent by using this property to determine whether or not a member, name, or key is guaranteed to be unique within the dimension (or level).
- When you need to improve server performance. Data can be more easily validated if you use this property to inform the server that a dimension key is not unique within the dimension or level.
使用例
' Assume the existence of a database dimension named dsoDim.
dsoDim.AreMemberKeysUnique = True
参照
関連項目
AreMemberNamesUnique (Dimension Interface)
AreMemberKeysUnique (Level Interface)
Dimension Interface