Skip to Content
author's profile photo Former Member
Former Member

Difference between Formula, Formula Key Figure & Formula Variable

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 03:32 PM


    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 :


    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)



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.