SkippedLevelsColumn (Level Interface)
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 SkippedLevelsColumn of the Level interface is used to define empty positions in a parent-child dimension.
Applies To:clsAggregationLevel, clsDatabaseLevel, clsCubeLevel, clsPartitionLevel
Data Type
String
Access
Access depends on the value of the ClassType property of the object. This property applies only to levels whose SubClassType is sbclsParentChild or sbclsMining.
Class type |
Access |
|---|---|
clsDatabaseLevel |
R/W |
clsCubeLevel |
R |
clsPartitionLevel |
R |
clsAggregationLevel |
R |
Remarks
This property contains the name of a column that stores the number of skipped (empty) levels between each member and its parent. This allows a parent-child hierarchy to skip levels between members. The values contained in this column must be nonnegative integers; otherwise a processing error occurs. If the column contains no value, the current member has a level depth one below its parent.