Symptom
- Cannot add Version dimension as the 2nd breakdown dimension in Waterfall chart in Optimized Experience Design story in SAP Analytics Cloud
- When adding version dimension not the 1st dimension, the Waterfall chart cannot be rendered and error appears as: The secondary dimension in a waterfall chart can't be a version dimension.
Environment
SAP Analytics Cloud 2025.8
Reproducing the Issue
- Create a new Optimized Experience Design story based on a planning model
- Add a waterfall widget.
- Assign a measure and add a dimension (not version dimension)
- The waterfall chart can be rendered correctly at this moment.
- Now add version dimension as the 2nd dimension of the waterfall chart.
- Chart cannot be rendered and error appears as: The secondary dimension in a waterfall chart can't be a version dimension.
Cause
- The behavior is BY DESIGN
- In Optimized Experience Design story case, as the error message text, Version dimension is not allowed to be used as the break down dimension.
Resolution
- Consider to put the Version dimension as the 1st dimension of the waterfall chart.
- Or consider to put the Version dimension as the color dimension of the waterfall chart.
See Also
- 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:
-
- 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.
Keywords
sap analytics cloud, waterfall chart, optimized story migration, secondary dimension, versioning, item order, story design, visualization, sort action, issue investigation , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem
Product
SAP Analytics Cloud 1.0