Express > Express Assembly Interfaces > IEaxDataAreaHierarchies > IEaxDataAreaHierarchies.FindByDE
FindByDE(S: IDimSelection; Key: Integer; de: Integer): IEaxDataAreaTransformation;
S. The dimension that contains an alternative hierarchy
Key. Dimension key.
de. Dimension element.
The FindByDE method searches data transformation formula by dimension element index.
If the formula is not found, the method returns Null.
To search for data transformation formula by dimension element identifier, use IEaxDataAreaHierarchies.Find.
Executing the example requires that the repository contains an express report with the EXPRESS identifier. The report contains a table.
Add links to the Dimensions, Express, Metabase system assemblies.
Sub UserProc;
Var
MB: IMetabase;
Express: IEaxAnalyzer;
Hiers: IEaxDataAreaHierarchies;
Slice: IEaxDataAreaSlice;
DimSel: IDimSelection;
Tr, TrDE: IEaxDataAreaTransformation;
Begin
// Get repository
MB := MetabaseClass.Active;
// Get express report
Express := MB.ItemById("EXPRESS").Bind As IEaxAnalyzer;
// Get data source slice
Slice := Express.DataArea.Slices.Item(0);
//Get dimension selection
DimSel := Slice.Selection.Item(3);
Hiers := Express.DataArea.Hierarchies;
Tr := Hiers.FindByDE(DimSel, Dimsel.Dimension.Key, DimSel.Element(3));
TrDE := Hiers.Find(DimSel, Dimsel.Dimension.Key, "Moscow");
If Tr = Null Then
Debug.WriteLine("Alternative hierarchy does not contain data transformation formulas") Else
Debug.WriteLine("Data transformation formula = " + Tr.Expression.AsString);
End If;
If TrDE = Null Then
Debug.WriteLine("Alternative hierarchy does not contain data transformation formulas") Else
Debug.WriteLine("Data transformation formula is deleted = " + TrDE.Expression.AsString);
Hiers.RemoveDependant(DimSel, Dimsel.Dimension.Key, "Moscow", TrDE);
End If;
End Sub UserProc;
After executing the example, the console displays data transformation of alternative hierarchy. If transformation formula is found by dimension element identifier, it will be removed.
See also:
