Express > Express Assembly Interfaces > IEaxDataAreaSlice > IEaxDataAreaSlice.GetTransformations
GetTransformations(Value: IDataAreaTransformationsGetter): IEaxDataAreaTransformations;
Value. Object which obtains collections of data transformation formulas.
The GetTransformations method returns collection of transformed data formulas.
To return dimension of analytical data area slice by its key, use IEaxDataAreaSlice.GetDimension.
Executing the example requires that the repository contains an express report with the EXPRESS identifier containing a 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 the collection of data transformation formulas from sorting
Trs := Express.DataArea.Slices.Item(0).GetTransformations(Getter);
// Display the number of data transformation formulas in the console window
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.
See also:
