SkippedLevelsColumn Element (ASSL)


This feature is discontinued in this version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Provides the details of a column that stores the number of skipped (empty) levels between each member and its parent.


   <SkippedLevelsColumn xsi:type="DataItem">...</SkippedLevelsColumn>

Element Characteristics

Characteristic Description

Data type and length


Default value



0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent elements


Child elements



The SkippedLevelsColumn element is applicable only to parent attributes (in other words, the value of the Usage element for the DimensionAttribute parent is set to Parent). The SkippedLevelsColumn element contains the column or attribute for the parent attribute that stores the number of skipped levels between each member and its parent member. This allows parent-child hierarchies that are based on the parent attribute to skip levels between members. The values contained in this column or attribute must be nonnegative integers; otherwise, a processing error occurs. If the SkippedLevelsColumn element is not specified or contains no value, the current member has a level depth one below its parent member.

For more information about the DataItem type, including a table of Analysis Services Scripting Language (ASSL) objects and properties of the DataItem table, see DataItem Data Type (ASSL).

The element that corresponds to the parent of SkippedLevelsColumn in the Analysis Management Objects (AMO) object model is DimensionAttribute.

See Also


Attributes Element (ASSL)
Dimension Element (ASSL)
Objects (ASSL)

Help and Information

Getting SQL Server 2005 Assistance