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

42 Views

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.