on 2019 Jul 11 10:59 PM
The Universal Display Hierarchy in our BW query is active for rows (expanded to level 1).
In our BEx Analyzer workbook, the Universal Display Hierarchy of that query is set to level 2 via VBA macro before the user saves the workbook (Event 'Workbook_BeforeSave'):
BEx.DataProviders.Item("DP_3").Request.Properties.SetUniversalPresentationHierarchyOnRows iActive:=True, iLevel:=2
Now, we want to convert the BEx Analyzer workbook into Analysis for Office (AO 2.7 SP1) workbook. Therefore, we need a similar API method in Analysis for Office in order to set the Universal Display Hierarchy to row level 2 via VBA macro. Does a VBA API method like e.g. 'setUniversalDisplayHierarchyOnRows' exists in AO?
Request clarification before answering.
User | Count |
---|---|
75 | |
21 | |
8 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.