SkippedLevelsColumn (Level Interface)

Analysis Services Programming

Analysis Services Programming

SkippedLevelsColumn (Level Interface)

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.

See Also

Level Interface

Parent-Child Dimensions

Ragged Dimension Support

SubClassType