Skip to Content
Author's profile photo Former Member

Local hierarchy in Analysis for Office – Grouping

Now Analysis for Office allows you to build custom hierarchies to display members listed under a node interactively. Besides using pre-defined hierarchies for certain dimensions, you can group members together as a hierarchical presentation if a dimension is displayed with its flat presentation.
You can separate these members again by ungrouping them. You can ungroup a single node or the complete custom hierarchy.

• You can group members of dimensions that are stored in an SAP BW system with version 7.50 SP6 or higher.
• Members in HANA data sources cannot be grouped.
• The dimension for which hierarchy is to be created, must be Hierarchy enabled in the BW system (using transaction RSD1).

For this demo, hierarchy is created on Oil Product Group (P_PRODUCT) dimension.
Below are the steps to check/enable hierarchies using t-code RSD1.

1. Enter technical name of Oil product group for Info Object.

2. Display hierarchy type properties and enable it.


1. Insert the corresponding data source
2. Select one or more members of a dimension in the crosstab.

3. Click on hierarchy –> Group members

The Group Header dialog appears.

4. Enter a name for the new node in Group Header field.
The name will be the header for the grouped members.
5. Press OK.

You have created a new hierarchy.

This new hierarchy behaves like the pre-defined ones. You can build several nodes as well as group several nodes to higher nodes.
To ungroup a single node, select the node and choose Hierarchy –> Ungroup Members. The created node is deleted and the former display is re-established.

To ungroup your complete custom hierarchy, select one element of the dimension and choose Hierarchy –> Ungroup All. The dimension is shown in flat presentation again.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hello Sowjanya,

      Thank you for the information. This is informative.

      A quick question. is this Custom Hiearchy created. Local to the report or it can be used like traditional parenth2 everywhere in all templates and calculations.?

      Author's profile photo Former Member
      Former Member

      Shankar - It gets created as local within the context of the AO workbook and shows up as "Custom hierarchy" in the hierarchy and is available only in the context of that workbook. if you need a global one, you should create a set hierarchy on the backend.

      Author's profile photo Bart Van Boxelaer
      Bart Van Boxelaer


      Is this only possible for dimensions with hierarchy enabled or ... also for display attributes (with hierarchy enabled) of a dimension?

      Author's profile photo Frank Carlsen
      Frank Carlsen


      We are trying to use this, but after creating the first group we get an ID-111006 error.

      Datasource is not a HANA datasource, Hierarchy is enable in the backend, and we are on 7.5 SP7

      Any ideas on how to fix it?