• Article

SkippedLevelsColumn Element (ASSL)

Note

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.

Syntax

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

Element Characteristics

Characteristic

Description

Data type and length

DataItem

Default value

None

Cardinality

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

Element Relationships

Relationship

Element

Parent elements

DimensionAttribute

Child elements

None

Remarks

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.