Express > Express Assembly Interfaces > IEaxDataAreaHierarchies > IEaxDataAreaHierarchies.Add
Add(Slice: IEaxDataAreaSlice;
DS: IDimSelection;
Key: Integer;
[ElementsToCopy: IDimSelection = Null]): IEaxDataAreaHierarchy;
Slice. Analytical data area slice.
DS. Dimension selection.
Key. Dimension key.
ElementsToCopy. Selection where elements of current selection will be added. Optional parameter, to ignore use Null.
The Add method adds new alternative hierarchy in collections.
To clear the collection of alternative hierarchies, use IEaxDataAreaHierarchies.Clear or IEaxDataAreaHierarchies.ClearAll.
Executing the example requires that the repository contains an express report with the EXPRESS identifier containing a table.
Add links to the Dimensions, Express, Metabase system assemblies.
Sub UserProc;
Var
MB: IMetabase;
Express: IEaxAnalyzer;
DArea: IEaxDataArea;
Slice: IEaxDataAreaSlice;
DimSel: IDimSelection;
Hiers: IEaxDataAreaHierarchies;
Hier: IEaxDataAreaHierarchy;
Begin
// Get repository
MB := MetabaseClass.Active;
// Get express report
Express := MB.ItemById("EXPRESS").Edit As IEaxAnalyzer;
// Get data source slice
DArea := Express.DataArea;
Slice := DArea.Slices.Item(0);
//Get dimension selection
DimSel := Slice.Selection.Item(0);
// Create a new alternative hierarchy of analytical data area
Hiers := DArea.Hierarchies;
Hier := Hiers.Add(Slice, DimSel, DimSel.Dimension.Key);
// Save changes
(Express As IMetabaseObject).Save;
End Sub UserProc;
After executing the example alternative hierarchy is created in express report.
See also:
