SkippedLevelsColumn (Level Interface)

ms133454.note(zh-tw,SQL.90).gif附註:
  下一版的 Microsoft SQL Server 將不再提供此功能。請勿在新的開發工作中使用此功能,並且儘速修改使用此功能的應用程式。

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

備註

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.

請參閱

參考

Level Interface
SubClassType (Level Interface)

說明及資訊

取得 SQL Server 2005 協助