SkippedLevelsColumn (Level Interface)

[!REMARQUE]

  Cette fonctionnalité sera supprimée dans la prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement, et modifiez dès que possible les applications qui utilisent actuellement cette fonctionnalité.

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

Notes

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.