SAP Knowledge Base Article - Public

3057967 - Waterfall chart : version dimension cannot be used in dimension and color section at the same time


The following behavior occurs in SAP Analytics Cloud (SAC):

  • Unable to use version based color in Waterfall Chart


  • SAP Analytics Cloud (Enterprise) 2021.7.2
  • Live BW Data Connection

Reproducing the Issue


  1. Create a Story based on Live BW Data Connection with Versions (i.e. Actual and/or Forecast)
  2. Add a Waterfall Chart with a Measure and Two Dimensions (Version and Category)
  3. Click on Designer
  4. Click on the Waterfall Chart on the Left
  5. Click on Color / Add Dimension - the version is greyed out / not available
    The Waterfall Chart has more than one version, however it does not allow to set the color based on the version


The behavior is intentional, designer's color feed for waterfall can only add "Version" dimension with configurable pattern but not color. 

The Help guide states:  “To use the Color parameter in a waterfall chart you need to have a Version (for example, Actual or Forecast) dimension. For your versions, you can modify the patterns, but not the colors. To change the colors, refer to Adding Columns and Customizing the Column Color-Coding”

In other words, if there are more than one version (e.g. actual and forecast) it will be created multiple waterfall charts instead of just one, that is similar trellis chart concept.

To explain, I would like to use a simple bar chat (left) and 2 waterfalls (right top, right bottom) as example.
For the bar chart, I added "version" to dimension and color feeds. For the waterfalls, right top I added "version" to the dimension feed and right bottom I added "version" to the color feed. You observe that when version is in dimension feed, it looks similar to the bar chart (except the pattern and color). However, for version in color feed waterfall, it creates 2 single bar charts, left for actual and right for the forecast for comparison side by side. 


If you then stack "Product" on the dimension feed for all 3 charts. you will be able to notice the difference among these charts. Hence, the Color Feed for a waterfall chart is specific to that comparison usage. If it allows "version" to be added on both dimension and color feed at the same time, then we CANNOT tell user want to do right top case OR right bottom case.


  • No available resolution

See Also

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,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped

, KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem


SAP Analytics Cloud 1.0