Difference between Formula, Formula Key Figure & Formula Variable

[Former Member]

Hi Experts,

I have a basic question in my mind:

1) What is the difference b/w Formula, Formula Variable, Formula Key Figure?

2) What is the difference b/w Selection, Filter and Restriction?

Can you pls explain with some scenarios? That will be helpful.

Thanks in Advance.

[gunesbt]

Hi,

You are right, these are basic questions and can be learnt just by a little bit searching.So search the forum before posting such questions please.

Nevertheless :

http://wiki.sdn.sap.com/wiki/display/BI/CalculatedKeyFigure+RestrictedkeyfigureFilter

http://help.sap.com/saphelp_nw04s/helpdata/en/61/d0b143aa26b849b4e79a859ea1d7d1/content.htm

Scenario:

You want to see the revenue that you get from Product A,B,C in the country of D and E.You also want to calculate a bonus value that will be given to distributors and this revenue will be calculated based on the user's input.E.g user inputs 5 and you give 5% of the sales to distributors.Then here, to get the input 5 and TO USE IT IN THE FORMULA ,you must create a formula variable.You also must a have key figure revenue to see the revenue of course and a calculated key figure(or a formula) called bonus value = formula variable*revenue/100 to calculate the bonus which will be given to distributors.

The other thing you must do is restricting product with A,B,C and country by D and E just by right clicking on them in query designer.What remains is the selection.Let's say you also want to see the total sales of A and B.Then create a selection in the columns then restrict it by dragging and dropping A and B and the key figure revenue.

By the way, filter(tab) is used to restrict the data coming from cube and affects everything in the report(in contrast to the restricting selection, because restricting selection affects only the selection, not other fields of the report)

Regards,

Güneş BÜYÜKTANIR