SAP Knowledge Base Article - Public

2538782 - Hierarchy nodes are shown in a flat list instead of a tree list when creating a filter on it from Live BW source in SAP Analytics Cloud

Symptom

  • Hierarchy nodes are shown in a flat list instead of a tree list when creating a filter on it from Live BW source in SAP Analytics Cloud
  • The "Multiple Selection Hierarchy" option is grayed out.
    Hi1.jpg

  • Hierarchy settings in Business Warehouse:
    • Display Parameters for Hierarchy Display in Query is set to: "Root/Totals Item Appears Below
      Hi3.jpg

  • The same hierarchy works fine in case of charts or tables.
  • Hi2.jpg

Environment

  • SAP Analytics Cloud 2017.17.1
  • SAP Business Warehouse
  • SAP BW4HANA 
  • Apache Reverse Proxy

Reproducing the Issue

  1. Create a Filter on Input Control in a new Story page from a hierarchy, which met the conditions described in the Symptom.

Cause

The issue is caused by a program error in Business Warehouse.

Resolution

Implement SAP Note, 2544905 - InA: issues with value help on hierarchies which are declared as node alignment 'Below'.

Workaround 1: 

  • Set Display Parameters for Hierarchy Display in Query to: "Root/Totals Item Appears Above"

Workaround 2:

  • Create a hierarchy node variable from the hierarchy and use it as prompt in SAP Analytics Cloud.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, filter, prompt, BW, live, HANA, IC, Root, total , KBA , bw , 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) , Bug Filed

Product

SAP Analytics Cloud 1.0