cancel
Showing results for 
Search instead for 
Did you mean: 

The sign reversal attribute of hierarchy and calculate a node of hierarhy in BEx report

Former Member
0 Kudos

Hello, colleagues.

I can’t understand the simple issue.

I want to use hierarchy with reversal sign parameter in my query. And I have been create formula variable from hierarchy attribute (like it described at this link: http://help.sap.com/saphelp_nw70/helpdata/en/e4/9eda3b2bc65e46a8ef0a7930b03d80/content.htm ). But then I got wrong result when node amount calculated the same way as leafs.

I try show example.

I have hierarchy:

Node1 (this is text node)

--Leaf1

--Leaf2

--Leaf3

And without sign reversal I get in report with my amount (KF1):

Node1 : KF1 = 200

Leaf1 : KF1 = 100

Leaf2 : KF1 = 70

Leaf3 : KF1 = 30

Then I set sign reverse parameter for Leaf2 and create calculated key figure with multiplayer based on sign attribute (KF2) and then I create one more calculated key figure which is equal KF1*KF2:

Node1: KF1 = 200, KF2 = 1, KF3 = 200

Leaf1 : KF1 = 100, KF2 = 1, KF3 = 100

Leaf2 : KF1 = 70, KF2 = -1, KF3 = -70

Leaf3 : KF1 = 30, KF2 = 1, KF3 = 30

So you can see that in KF3 I get KF1 * KF2 but I want to get sum of KF3 from leafs, KF3 = 100-70+30=60.

Can anybody advise me what wrong with my query?

I can see that in help of SAP they got the same result (http://help.sap.com/saphelp_nw70/helpdata/en/ea/2b0998397611d5b2e80050da4c74dc/content.htm ). Is it mean that sign reversal just for view and almost useless because it can’t be used for create any reports like indirect cash flow?

WBR, Andrey.

Accepted Solutions (0)

Answers (1)

Answers (1)

cornelia_lezoch
Active Contributor
0 Kudos

Hi Andrey,

for your KF3 what calculation mode is set for results?

Set it to summation.

regards

Cornelia