DimensionAttribute.SkippedLevelsColumn Property

Applies To: SQL Server 2016 Preview

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

Namespace:   Microsoft.AnalysisServices
Assembly:  Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)

Syntax

[TypeConverterAttribute("Microsoft.AnalysisServices.Design.DataItemTypeConverter, Microsoft.AnalysisServices.Design")]
[EditorAttribute("Microsoft.AnalysisServices.Design.DataItemPropertyTypeEditor, Microsoft.AnalysisServices.Design", 
    typeof(UITypeEditor))]
[MergablePropertyAttribute(false)]
[XmlElementAttribute(IsNullable = false)]
[BrowsableAttribute(false)]
[DefaultValueAttribute(null)]
public DataItem SkippedLevelsColumn { get; set; }

public:
[TypeConverterAttribute("Microsoft.AnalysisServices.Design.DataItemTypeConverter, Microsoft.AnalysisServices.Design")]
[EditorAttribute("Microsoft.AnalysisServices.Design.DataItemPropertyTypeEditor, Microsoft.AnalysisServices.Design", 
    (UITypeEditor^::typeid))]
[MergablePropertyAttribute(false)]
[XmlElementAttribute(IsNullable = false)]
[BrowsableAttribute(false)]
[DefaultValueAttribute(null)]
property DataItem^ SkippedLevelsColumn {
    DataItem^ get();
    void set(DataItem^ value);
}

[<TypeConverterAttribute("Microsoft.AnalysisServices.Design.DataItemTypeConverter, Microsoft.AnalysisServices.Design")>]
[<EditorAttribute("Microsoft.AnalysisServices.Design.DataItemPropertyTypeEditor, Microsoft.AnalysisServices.Design",
    typeof(UITypeEditor))>]
[<MergablePropertyAttribute(false)>]
[<XmlElementAttribute(IsNullable = false)>]
[<BrowsableAttribute(false)>]
[<DefaultValueAttribute(null)>]
member SkippedLevelsColumn : DataItem with get, set

<TypeConverterAttribute("Microsoft.AnalysisServices.Design.DataItemTypeConverter, Microsoft.AnalysisServices.Design")>
<EditorAttribute("Microsoft.AnalysisServices.Design.DataItemPropertyTypeEditor, Microsoft.AnalysisServices.Design",
    GetType(UITypeEditor))>
<MergablePropertyAttribute(False)>
<XmlElementAttribute(IsNullable := False)>
<BrowsableAttribute(False)>
<DefaultValueAttribute(Nothing)>
Public Property SkippedLevelsColumn As DataItem

Property Value

Type: Microsoft.AnalysisServices.DataItem

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

Remarks

The SkippedLevelsColumn property is applicable only to parent attributes (that is, the value of the Usage is set to Parent). The SkippedLevelsColumn property 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 property is not specified or contains no value, the current member has a level depth one below its parent member.

See Also

DimensionAttribute Class
Microsoft.AnalysisServices Namespace

Return to top