SAP Knowledge Base Article - Public

3312855 - Cannot change order of the displayed measures when using hierarchies and selecting an specific node

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

  1. Open the required query in AO;
  2. Go to the Design Panel -> Right click on Measures -> Filter by Member;
  3. Select the members you wish to sort its order;
  4. 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;
  5. In order to have just the secondary (or other levels) node displayed in the required order, perform the steps below:
    1. Select the hierarchy to be used;
    2. Click on Hierarchy option -> Show Levels;
    3. Untick the levels before the one you want to have it displayed and which is placed in the middle of the dimensions, as required;
  6. 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:

    1. Select the hierarchy to be used;
    2. Click on Hierarchy option -> Show Levels;
    3. 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