SAP Knowledge Base Article - Public

3420253 - The connecting line between the Account member parent node and its child nodes is not vertical but slanted in a Waterfall Chart in SAP Analytics Cloud (SAC)

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

  1. Log onto SAC
  2. Create a classic story or a story with Optimized Design Experience mode enabled
  3. Insert a Waterfall Chart into this story
  4. 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"
  5. 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

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