TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

SkippedLevelsColumn Element (ASSL)

 

Applies To: SQL Server 2016 Preview

System_CAPS_ICON_note.jpg 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.

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

CharacteristicDescription
Data type and lengthDataItem
Default valueNone
Cardinality0-1: Optional element that can occur once and only once.
RelationshipElement
Parent elementsDimensionAttribute
Child elementsNone

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.

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

Community Additions

ADD
Show:
© 2016 Microsoft