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, use IEaxDataAreaSlice.GetDimension.
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.
See also: