Symptom
How to display the hierarchies and dimensions in an specific order (sorting behavior) if just a node of the hierarchy is required and not its main node.
Environment
SAP Analysis for Microsoft Office.
Reproducing the Issue
- Open the required query in AO;
- Go to the Design Panel -> Right click on Measures -> Filter by Member;
- Select the members you wish to sort its order;
- Once the data is filtered, sort the dimensions as required and place the main node of the hierarchy where you wish to have the secondary (or other levels) node;
- In order to have just the secondary (or other levels) node displayed in the required order, perform the steps below:
- Select the hierarchy to be used;
- Click on Hierarchy option -> Show Levels;
- Untick the levels before the one you want to have it displayed and which is placed in the middle of the dimensions, as required;
- The results should be displayed as required.
Resolution
In order to have just the secondary (or other levels) node displayed in the required order, perform the steps below:
-
- Select the hierarchy to be used;
- Click on Hierarchy option -> Show Levels;
- Untick the levels before the one you want to have it displayed and which is placed in the middle of the dimensions, as required;
Keywords
hierarchy, Show Levels, display, measures, dimension, sorting, order, node, parent node, child node. , KBA , BI-RA-AO-XLA , Excel Addin , How To
Product
SAP Analysis for Microsoft Office 2.8