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
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.
Thanks for sharing.
The link to the note you mention is http://service.sap.com/sap/support/notes/2147448, 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\).