on 2025 Nov 11 5:02 PM
Hi ,
I'm having difficulty to create hierarchy in Datasphere.
In my scenario, I want to use all nodes of the hierarchy as leaf node, as we are also posting amounts to upper nodes. Sample below, we have entries for 11 (is also including its own entries as 500 other than values from its sub nodes 11A and 11B) and 11A and 11B.
Root Node Total amount to be shown 1800
Level 1 : Node ID 11 is having amount 500
Level2 : Node ID 11A child of 11 is having amount 600
Level2 : Node ID 11B child of 11 is having amount 700
In datasphere if I create a hierarchy, it is showing total amount as 1300 (sum of 11A and 11B) even after defining all nodes as leaf nodes. The same hierarhcy is working fine on S/4 HANA based hierarchy, as S/4 HANA is showing the additional amounts under not assgined and as total I can see 1800. I owuld like to know if it is also possible to define same in Datasphere hierarchy ?
Thanks
Request clarification before answering.
I have noticed that the issue was already resolved after setting all nodes as leaf node. I didn't notice it before because of some missing hierarchies nodes in datasphere the amounts were showing different results.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 11 | |
| 6 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.