SAP Knowledge Base Article - Public

3618757 - Cannot add Version dimension as the 2nd breakdown dimension in Waterfall chart in Optimized Experience Design story in SAP Analytics Cloud

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

  1. Create a new Optimized Experience Design story based on a planning model
  2. Add a waterfall widget.
  3. Assign a measure and add a dimension (not version dimension)
  4. The waterfall chart can be rendered correctly at this moment.
  5. Now add version dimension as the 2nd dimension of the waterfall chart.
  6. 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

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