Skip to Content
Author's profile photo Eric Yew

SAP Analytics Cloud – Universal Display Hierarchy support with SAP BW

You may have noticed with 2018.07 release that SAP Analytics Cloud now supports the “Universal Display Hierarchy” setting that is defined in the BW Query. This applies to live connections to SAP BW.

What is the Universal Display Hierarchy?

Universal Display Hierarchy is a BW Query setting concept that allows two or more dimensions defined in the row or columns to be displayed hierarchically. This is a setting that can be activated in the rows and/or columns. You can even set the default expansion level of the hierarchy display.

So now, as example, if we have the following Dimensions and Measures defined along the rows and columns respectively in the BW Query:

The table/grid visualization in SAP Analytics Cloud will now be able to leverage the Universal Display Hierarchy as a runtime concept.

Please note that only table/grid visualizations support the Universal Hierarchy Display concept. This is not supported for Chart visualizations within the Story, as the initial view of the query as defined in the BW Query Designer is only applicable for table/grid visualizations.

To leverage Universal Hierarchy Display support with SAP Analytics Cloud, please be sure that your SAP BW system has the latest SNOTES applied. We recommend that you run the SAP Note Analyzer report to download and install the latest SNOTES required for baseline support!


Eric Yew

Assigned Tags

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

      Nice! What are the BW system requirements for this? 7.4? 7.5? Which SP?

      Author's profile photo g M
      g M

      HI thanks for the information, in out case we are unable to display ID and description both on second level. It is taking either ID or description to display. Any help here