cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Datasphere hierarchy, how to enable node level posting

EAkin
Explorer
0 Likes
221

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 

Accepted Solutions (0)

Answers (1)

Answers (1)

EAkin
Explorer
0 Likes

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.