Hierarchy Nodes not adding up.

[Former Member]

in my report, one of the heirarchy nodes is not adding up correctly with the values from its sub-devisions. For example, the field selling value for my top node should be the sum of all the field selling values of its sub-devisions (dont know if i'm using the correct term, but hope u understand). What could be the reason for this. Let me know if you need more info.

Thanks

Fran

[former_member188975 · Accepted solution]

Hi Fran,

Check if there is a value with the top node. See this link for an example of the same. Scroll down to Presentation Hierarchy > Values of POsted Nodes:

http://help.sap.com/saphelp_nw04/helpdata/en/1a/25213c9cffa027e10000000a11402f/content.htm

Hope this helps...

[Former Member · Accepted solution]

Bhanu, thanks for the help. I didnt understand your question "check if there is a value with the top node" could you please elaborate what you mean by this ??

thanks

Fran

[former_member188975 · Accepted solution]

If you see the link that I sent, there is an example of this situation. eg:

N1 100

-NA 30

-NB 40

-NC 20

Here the numbers do not add up, reason being that N1 carries a value of 10, which is not shown by default.

Hope this helps...

[Former Member · Accepted solution]

you are right. i get the concept now. But in one of the cases in my report....the value that should be added up is actually less than that of one of its subordinates. What could be the reason for that???

thanks

Fran

[former_member188975 · Accepted solution]

Could there be a negative value with the top node then?

[Former Member · Accepted solution]

Thats what I thought initially, but i dont think so because the KF is for headcount of employees. And this is for planning data (I think coming from SEM). So i dont know if they could use negative numbers for headcount.

Any thoughts?

thanks

Fran

[former_member188975 · Accepted solution]

How do the numbers look if you turn off the hierarchy in the report?

[Former Member · Accepted solution]

The screenshot that the user sent me, the number didnt add up properly. But when I ran the report with the same variant, its matching now...i dont know whats going on.

[Former Member]

Fran,

This could be one of the possible reasons. Did you check authorizations for ur user ID?

Your user ID might have been restricted to see only certain nodes under a node. Check the user profile to see this is the case. You can check this if you authorizations for RSSM, else talk to ur security people.

Or test with a userID, which doesn't have any restrictions for that hierarchy.