IPivotTableHeader.IsCombinedSlot

Syntax

IsCombinedSlot(SlotNumber: Integer): Boolean;

Parameters

SlotNumber.Slot index in the table header.

Description

The IsCombinedSlot property returns whether there are several dimensions placed in one row and column in the table header.

Comments

If table header contains several dimension names placed in one row and column when the All Dimensions checkbox is selected, the property returns True, otherwise - False.

Example

Executing the example requires that the repository contains an express report with a data table with the EXPRESS_SLOTS identifier.

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

Sub UserProc;
Var
    MB: IMetabase;
    Report: IEaxAnalyzer;
    Pivot: IPivot;
    TableHeader: IPivotTableHeader;
    Dims: String;
Begin
    // Get the current repository
    MB := MetabaseClass.Active;
    // Get express report
    Report := MB.ItemById("EXP_SLOTS").Bind As IEaxAnalyzer;
    // Get object, based on which data table is built
    Pivot := Report.Pivot;
    // Get properties of table column headers
    TableHeader := Pivot.ObtainTable.TopHeader;
    // Get header of the first table column
    Dims := TableHeader.GetSlotName(True, False, 0);
    // Determine whether the header contains several dimensions in one row
    If TableHeader.IsCombinedSlot(0) = True Then
        Debug.WriteLine("In the first table column header the dimensions with the following names are combined - " + Dims);
        Else Debug.WriteLine("Dimensions are not combined in the header");
    End If;
End Sub UserProc;

After executing the example the console window displays names of combined dimensions or the message that dimensions are not combined in the header:

In the first table column header, the dimensions with the following names are combined - Calendar; Data types

See also:

IPivotTableHeader