IEaxDataAreaSlice.GetTransformations

Fore Syntax

GetTransformations(Value: IDataAreaTransformationsGetter): IEaxDataAreaTransformations;

Fore.NET Syntax

GetTransformations(Value: Prognoz.Platform.Interop.ForeSystem.IDataAreaTransformationsGetter): Prognoz.Platform.Interop.Express.IEaxDataAreaTransformations;

Parameters

Value. Object which obtains collections of data transformation formulas.

Description

The GetTransformations method returns collection of transformed data formulas.

Comments

To return dimension of analytical data area slice, use IEaxDataAreaSlice.GetDimension.

Fore Example

Executing the example requires that the repository contains an express report with the EXPRESS identifier containing table. To sort data in the table, several formulas must be added.

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

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    SortItem: IPivotSortItem;
    Getter: IDataAreaTransformationsGetter;
    Trs: IEaxDataAreaTransformations;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get express report
    Express := MB.ItemById("EXPRESS").Bind As IEaxAnalyzer;
    // Get table
    Pivot := Express.Pivot;
    // Get sorting
    SortItem := Pivot.Sorter.Item(0);
    Getter := SortItem As IDataAreaTransformationsGetter;
    // Get collection of formulas of data transformation from sorting
    Trs := Express.DataArea.Slices.Item(0).GetTransformations(Getter);
    // Display to the console number of data transformation formulas
    Debug.WriteLine("Number of data transformation formulas = " + Trs.Count.ToString);
End Sub UserProc;

After executing the example, the console displays number of data transformation formulas specified in sorting.

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.ForeSystem;
Imports Prognoz.Platform.Interop.Pivot;
…
Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    SortItem: IPivotSortItem;
    Getter: IDataAreaTransformationsGetter;
    Trs: IEaxDataAreaTransformations;
Begin
    // Get repository
    MB := Params.Metabase;
    // Get express report
    Express := MB.ItemById["EXPRESS"].Bind() As IEaxAnalyzer;
    // Get table
    Pivot := Express.Pivot;
    // Get sorting
    SortItem := Pivot.Sorter.Item[0];
    Getter := SortItem As IDataAreaTransformationsGetter;
    // Get collection of formulas of data transformation from sorting
    Trs := Express.DataArea.Slices.Item[0].GetTransformations(Getter);
    // Display to the console number of data transformation formulas
    System.Diagnostics.Debug.WriteLine("Number of data transformation formulas = " + Trs.Count.ToString());
End Sub;