The IsUnique property of the Level interface indicates whether the members for a level are uniquely identified by the level’s member key column alone.
| clsAggregationLevel | clsDatabaseLevel |
| clsCubeLevel | clsPartitionLevel |
Boolean
The access type depends on the level object class.
| Class | Access |
|---|---|
| clsDatabaseLevel | R/W |
| clsCubeLevel | R |
| clsPartitionLevel | R |
| clsAggregationLevel | R |
If the IsUnique property is True, the level’s MemberKeyColumn property uniquely identifies all level members. For example, in the following diagram, the member key column for Level 2 -Years would be all that is required to uniquely identify the levels 1997 and 1998. However, the member key column alone for Level 3 - Quarters would not uniquely identify a quarter since the levels are duplicated under each year level. To uniquely identify the level 1997 - Q1, the member key columns for Level 2 - Years and Level 3 - Quarters would need to be combined.
If a new level for months of the year named Month1, Month2, ... Month12 were added below the quarter level, the IsUnique property would be set to False, because MemberKeyColumn would not uniquely identify each month level.
' Assume an object (dsoDim) of ClassType clsDimension exists
Dim dsoLevel As DSO.Level
Set dsoLevel = dsoDim.Levels.AddNew("Months")
dsoLevel.IsUnique = False
| About Decision Support Objects | Using Decision Support Objects |
| Properties Cross-Reference |