IEaxDataAreaPivotSlice.Pivot

Syntax

Pivot: IPivot;

Description

The Pivot property returns object to work with base to build data table.

Example

Executing the example requires:

Both reports are based on the same data source. Table formatting style is changed in express report.

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

Sub UserProc;
Var
    MB: IMetabase;
    Report: IPrxReport;
    DataArea: IEaxDataArea;
    RepGrid, EaxGrid: IEaxGrid;
    PivSlice, Slice: IEaxDataAreaPivotSlice;
    Pivot: IPivot;
    CombSel: IDimSelection;
    Express: IEaxAnalyzer;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get analytical data area of regular report
    Report := MB.ItemById("REPORT").Edit As IPrxReport;
    DataArea := Report.DataArea;
    // Get table data view
    RepGrid := DataArea.Views.Item(0As IEaxGrid;
    // Get base for building analytical data area slice
    PivSlice := DataArea.Slices.Item(0As IEaxDataAreaPivotSlice;
    // Display the number of dimensions in the console window
    Pivot := PivSlice.Pivot;
    Debug.WriteLine("Number of dimensions = " + Pivot.DimCount.ToString);
    // Display metric dimension selection in the console window
    CombSel := PivSlice.CombinedIndicatorSelection;
    Debug.WriteLine("Metric dimension selection elements = " + CombSel.ToString(""", "False));
    // Get express report
    Express := MB.ItemById("EXPRESS").Bind As IEaxAnalyzer;
    // Get base to build slice
    Slice := Express.DataArea.Slices.Item(0As IEaxDataAreaPivotSlice;
    // Get express report table
    EaxGrid := Express.Grid;
    // Apply slice and data view
    PivSlice.Apply(Slice, EaxPivotSliceApplyOptions.Default_);
    RepGrid.Apply(EaxGrid, EaxGridApplyOptions.Default_);
    (Report As IMetabaseObject).Save;
End Sub UserProc;

After executing the example, the console displays the number of dimensions in the slice, selection elements of metrics dimension. Express report settings are imported to regular report analytical data area.

See also:

IEaxDataAreaPivotSlice