3560410 - Members in waterfall chart showing incorrect sequence when using unbooked value, calculated dimension in SAP Analytics Cloud (SAC)

Incorrect sequence of data members is appearing in a waterfall chart of a story in SAC

SAP ANALYTICS CLOUD: 2024.21.8 

1. Login to SAC
2. Create a story
3. Create a waterfall chart using unbooked value for the datapoint. 
   
   Notice that members in waterfall chart will appear in incorrect sequence. 

• This is a limitation of the waterfall chart. 
• Unbooked data is not supported for calculated dimensions. 

To fix this, force a zero value into the unbooked dimension member. This can be done by creating an extra measure that will have a zero value for it and including it in the calculation. 

• 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 an 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.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.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!

miss, matched, incorrect, sequence, calculated, dimension, waterfall, chart, unbooked, values, data  , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem