Skip to Content
Author's profile photo Torsten Wirth

New feature of AO for hierarchies in columns

In the versions AO 1.4 SP13, AO 2.0 SP 4, AO SP 1 there is a new feature for hierarchical display in columns available.

This setting is described in 2147448 but up to now not in the AO Adminguide.

The standard compact design of AO in past looks like this:


With the new option activated it looks like this:


File to be modified to activate this setting: ao_app.config

Path: C:\ProgramData\SAP\Cof

Upper part of the file:

<section name=”WrapHierarchyNodesInColumns” type=”String” configurationLevel=”UserRoaming” />

Lower part of the file:

<!–default: value=”False” –>

<WrapHierarchyNodesInColumns value=”True” />

You can check the result with a cube which includes time dimensions. Add the keyfigures to the rows, add year, quarter, month to columns. Choose compact design of hierarchies. Now you are getting a result which looks pretty much like the examples above.

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Thomas Nielsen
      Thomas Nielsen

      Thanks for sharing.

      The link to the note you mention is, and I had to read that, since the ao_app.config file is only for AO version 2+.

      The former version 1.4 is still using the registry, and if not all has access to the support note, here is the registry key that needs changing in version 1.4

      To activate the new behavior in Analysis for Office 1.4 you need to add the string value "WrapHierarchyNodesInColumns" with value "True "in the registry under


      (on 32 bit operating systems use HKEY_LOCAL_MACHINE\SOFTWARE\SAP\AdvancedAnalysis\Settings\UiCommon\).