Symptom
- When creating a Variance Waterfall chart based on hierarchical Account, observe that the connecting line between the parent node and its child nodes is not vertical but slanted, and it seems that there is gap between the exact value of parent node and the sum of its child nodes
Environment
- SAP Analytics Cloud: 2023.21.13
Reproducing the Issue
- Log onto SAC
- Create a classic story or a story with Optimized Design Experience mode enabled
- Insert a Waterfall Chart into this story
- On Builder panel of this Waterfall chart, configure as below:
- Chart Orientation: Horizontal
- Account Hierarchy: select a hierarchy
- Accounts: Select several account members and make sure at least one parent node and its child nodes have been selected.
- Measures:
- Dimension: Version
- Filters: Add a filter based on this Version dimension select at least two members
- Turn on the button "Variance Waterfall"
- After the above configuration on above Step4
=>Observe that a Waterfall chart which compares the value differences between versions would appear
=> Also observe that the connecting line between the parent node and its child nodes is not vertical but slanted, and it seems that there is gap between the exact value of parent node and the sum of its child nodes
Cause
- In model, Account type is not set for the Accounts that are being used in this Waterfall Chart
Resolution
- In model, set the type of related Account members that are being used in this Waterfall Chart as "EXP".
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 incident for 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 > Learning > Data Connections
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base
Keywords
sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, Story, story, Stories, stories, Story 2.0, story 2.0, Optimized Design Experience mode, ODE, ode, Optimized View mode, OVM, ovm, waterfall chart, parent node, child node, vertical, slanted, gap, bridge, line up , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem
Product
SAP Analytics Cloud 1.0