SAP Knowledge Base Article - Public

2775869 - Wrong default hierarchy order when using an SAP BW Live Connection in SAP Analytics Cloud (SAC) & SAP Digital Boardroom


Hierarchies based from a BW Live Data Connection, are shown in the wrong order by default in SAP Analytics Cloud (SAC)


  • SAP Analytics Cloud 2019.6.3
  • SAP Business Warehouse (BW) version 7.5 SP12

Reproducing the Issue

  1. Log in to SAP Analytics Cloud
  2. Open a story which is based on a BW Live Data Connection with hierarchies enabled
  3. Create a table and observe the hierarchy is ordered differently to how it has been saved in BW


This issue is currently under investigation by Development.


  • This issue is currently under investigation by Development, however, please apply necessary SAP BW Notes by running the Z_SAP_BW_NOTE_ANALYZER program attached to SAP Note 2541557.
    The user guide is located on the help portal: SAP BW Note Analyzer user guide.
  • For remote blending see SAP Note 2715871 - BW - SAP Analytics Cloud remote blending.

See Also

Your feedback is important to help us improve our knowledge base.


SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem


SAP Analytics Cloud 1.0