Query Design - Keyfigure attribute in the calculation

[Former Member]

Hi,

I have an infoObject with "Standard Balance" (a key figure) as an attribute. InfoObject has been added to the InfoCube.

In my InfoCube I have another Keyfigure called "Actual balance".

Now, in the query I would like to check the difference between the two (Actual Balance - Standard Balance). If this difference is positive, then I would like to display the row, else, I don't want to display it at all...

Any suggestions/ideas are appreciated.

Thanks

John

[Former Member · Accepted solution]

1- to capture the KF-attribute in the query, create a formula variable of type replacement path (go into the formula designer and create a new formula.. it's pretty straightforward)

(http://help.sap.com/saphelp_nw04/helpdata/en/03/6ba03cc24efd1de10000000a114084/frameset.htm)

2- the create a CKF or formula to calculate the difference between the 2

3- use a condition to filter on your new CKF/formula from step 2 to show only the rows where this calculation is positive

(http://help.sap.com/saphelp_nw04/helpdata/en/43/b57138c1afbd20e10000009b38f889/frameset.htm)