IPivotTableHeader.SlotDims

Syntax

SlotDims(SlotNumber: Integer): Array;

Parameters

SlotNumber. Slot index in the header.

Description

The SlotDims property returns the array of dimension keys located in the specified header slot.

Example

Executing the example requires that the repository contains an express report with the EXPRESS_REPORT identifier.

Add links to the Express, Metabase and Pivot system assemblies.

Sub UserProc;
Var
    Mb: IMetabase;
    Expr: IEaxAnalyzer;
    Pivot: IPivot;
    Header: IPivotTableHeader;
    DimArr: Array Of Integer;
    i, c: Integer;
Begin
    Mb := MetabaseClass.Active;
    Expr := Mb.ItemById("EXPRESS_REPORT").Bind As IEaxAnalyzer;
    Pivot := Expr.Pivot;
    // Row header
    Header := Pivot.ObtainTable.LeftHeader;
    c := Header.SlotCount;
    For i := 0 To c - 1 Do
        DimArr := Header.SlotDims(i);
        Debug.WriteLine("Slot: " + i.ToString);
        // View information about dimensions in header slots
        ShowArray(Mb, DimArr);
    End For;
End Sub UserProc;

Sub ShowArray(Mb: IMetabase; DimArr: Array Of Integer);
Var
    MDesc: IMetabaseObjectDescriptor;
    Key: Integer;
Begin
    Debug.Indent;
    For Each Key In DimArr Do
        MDesc := Mb.Item(Key);
        Debug.WriteLine(MDesc.Name + '(' + MDesc.Id + ')');
    End For;
    Debug.Unindent;
End Sub ShowArray;

After executing the example the development environment console displays the information about the dimensions located in single slots of the row header.