IPivotTableHeader.IsDimensionMergeAllowed

Syntax

IsDimensionMergeAllowed(DimKey: Integer): Boolean;

Parameters

DimKey. Dimension key.

Description

The IsDimensionMergeAllowed property returns whether the dimension contained in table header can be tucked.

Comments

Available values:

Example

To execute the example, make sure that the repository contains an express report with the EXPRESS identifier. The express report contains two dimensions located in rows and joined into one slot.

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

Sub Main;
Var
    MB: IMetabase;
    Report: IEaxAnalyzer;
    Pivot: IPivot;
    info: String;
    TableHeader: IPivotTableHeader;
    dimKey: Integer;
Begin
    
// Get the current repository
    MB := MetabaseClass.Active;
    
// Get express report
    Report := MB.ItemById("EXPRESS").Bind As IEaxAnalyzer;
    
// Get object, based on which data table is built
    Pivot := Report.Pivot;
    
// Get table sidehead properties
    TableHeader := Pivot.ObtainTable.LeftHeader;
    
// Check if the first dimension is tucked
    dimKey := Pivot.LeftHeader.Dim(0).Key;
    info := Pivot.ObtainTable.LeftHeader.IsDimensionMergeAllowed(dimKey).ToString;
    Debug.WriteLine(info);
    
// Check if the second dimension is tucked
    dimKey := Pivot.LeftHeader.Dim(1).Key;
    info := Pivot.ObtainTable.LeftHeader.IsDimensionMergeAllowed(dimKey).ToString;
    Debug.WriteLine(info);
End Sub Main;

After executing the example the console window displays False for the first dimension because tucking is available for all dimensions but the first one, and True for the second dimension.

See also:

IPivotTableHeader