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.

See Also

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