IEaxDataAreaSlice.AdditionalFilterTransformations

Syntax

AdditionalFilterTransformations: IEaxDataAreaTransformations;

Description

The AdditionalFilterTransformations property returns object to work with collection of columns transformation in case of separate filtering of table rows and columns is enabled.

Comments

Separated filtering for rows and columns is determined by the IPivotFilter.SeparateHeaders property. On executing separated filtering, transformations for columns are in this collection. Is separated filtering is not used, the collection will be empty.

Example

Executing the example requires that repository has regular report with the EXPRESS_FILTER identifier. The report contains table. The report must contain separated filtering for rows and columns. For rows filtering settings several formulas must be set. The setting is made using the FilterSetup command of the Express plagin.

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

Sub main;
Begin
    UserProc;
End Sub main;

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Dim: IEaxDataAreaSlice;
    Top: IEaxDataAreaTransformations;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get express report
    Express := MB.ItemById("EXPRESS_FILTER").Bind As IEaxAnalyzer;
    // Get table displaying settings
    Dim := Express.DataArea.Slices.Item(0);
    Top := Dim.AdditionalFilterTransformations;
    Debug.WriteLine("Number of transformations set for columns = " + Top.Count.ToString);
End Sub UserProc;

After executing the example the console displays number of columns transformation on activated separated filtering for table rows and columns.