IPivotTableHeader.IsCombinedSlot

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.

Fore 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

Fore.NET Example

The requirements and result of the Fore.NET example execution match with those in the Fore example.

Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Metabase;
Imports Prognoz.Platform.Interop.Pivot;
…
Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Report: IEaxAnalyzer;
    Pivot: IPivot;
    TableHeader: IPivotTableHeader;
    DimKey, Element: Uinteger;
    Dims: String;
    DimInst: IDimInstance;
Begin
    // Get the current repository
    MB := Params.Metabase;
    // 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
        System.Diagnostics.Debug.WriteLine("In the first table column header the dimensions with the following names are combined  - " + Dims);
        Else System.Diagnostics.Debug.WriteLine("Dimensions are not combined in header");
    End If;
End Sub;

See also:

IPivotTableHeader