SkippedLevelsColumn Element (ASSL)
Applies To: SQL Server 2016 Preview
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>
|Data type and length||DataItem|
|Cardinality||0-1: Optional element that can occur once and only once.|
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.