3311828 - The hierarchy selected for one dimension in Builder will be reset by selection of hierarchy variable based on Live BW connection in SAP Analytics Cloud (SAC)

• The hierarchy selected for one dimension in Builder will be reset by selection of hierarchy variable based on Live BW connection in SAP Analytics Cloud (SAC)
• If you don't choose value for the hierarchy variable as it is optional, the dimension will be reset to flat presentation.

• SAP Analytics Cloud, Enterprise Edition
• SAP Analytics Cloud, Embedded Edition for S/4HANA Cloud
• Live Data connection to SAP BW or SAP S/4HANA

1. Log on to SAC tenant.
2. Create one story with Table based on BW query with Hierarchy Variable via Live Data connection to SAP BW or SAP S/4HANA.
3. In Set Variable Dialog, select one value for the Hierarchy Variable.
4. Add the same dimension into Rows of the table.
   => The dimension will show the hierarchy according to selection in Set Variable dialog.
5. Click Hierarchy from context menu of the dimension in Builder.
6. Change the hierarchy to another one, which is different from the selection of Hierarchy Variable.
   => The dimension will show the new hierarchy in the table.
7. Try to change the Prompt of either story or table.
8. In Set Variable dialog, for the hierarchy variable,  keep the original selection in step 3, or change to another hierarchy different from the selection in step 5 .
9. Click Set.
   => The hierarchy selected for the dimension in step 5 will be reset and the dimension will always show the hierarchy selected for the hierarchy variable.
   => If you don't choose any value for the hierarchy variable as it is optional, the dimension will be reset to flat presentation.
   => Same behavior could be observed when reopening the story.

• This is by-design.
• The selected value for hierarchy variable in Set Variable dialog will be always respected, even different hierarchy may be selected statically for same dimension in Builder.
• Similar behavior could be also reproduced when executing same BW query through RSRT or other BW clients.

Reconsider the design of either story or BW query:

• If you want to enable end users to select the hierarchy dynamically, please use Hierarchy Variable.
• If you want to keep static hierarchy for all users, please remove Hierarchy Variable from the BW query and then set Hierarchy in Story Builder.

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
  
  • https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

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

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, BW, S/4HANA, S4, Live, Query, Hierarchy, Variable, Selection, Selected, Value, Filter, Builder, Designer , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , LOD-ANA-DES , Story Design & Visualizations , Problem