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

BEx

Hi,

Kindly note, I dont need std docs or any links to any forums.

what is a calculated key figure. How to create it. Pls. give an example of its use.

what is a restricted key figure, its use and how to create.

How to create variables.

Pls. explain step by step.

Thanks,

raj

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2006 at 08:57 AM

    Hi,

    1.what is a calculated key figure. How to create it.

    calculated key figure - when you do some calculation on an existing key figure. you right click on key figure & create new calculate key figure & in that window you decide the name of new key figure & define the formula / logic etc. Example - say I have a key figure value & I want to show values as divide by 5 ( or some other figure) so I define a new key figure as calculated key figure & define logic there. and also I need to go to prpoerties of existing ( old) key figure & hide it .

    2.what is a restricted key figure, its use and how to create - it is when I restrict the value of a key figure based on the value of a characteristics. again you create it by right click & giving name & also choosing key figure( existing KF) & char with value ( on which KF is to be restricted). for example sales is the KF which has values for year 1 & year2, you want to show the values year wise like Year1 Sales, Year2 Sales so you create two restricted key figures & reastrcit one on year1 & 2 on year2.

    hope it helps

    regards

    Vikash

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2006 at 08:45 AM

    restricted key figure

    A Restricted Key Figure is used in BW queries to limit the output of a key figure to particular characteristic values. Eg. you need to display sales only for year 2004, then you can create a restricted key figure (RKF) by using Sales > right click> Restrict by CalYear value 2004. You can also include variables in the restrictions, like Sales restricted to a year chosen by the user.

    Restricted Key Figures can be created locally i.e. for a particular query, or they can also be created globally (on the left hand side in the query designer) for use in all queries on the particular InfoProvider.

    calculated key figures

    You can create calculated key figures in the query definition. These CKF can be local, i.e. specific to the query or global i.e. available for all queries created on the InfoProvider. You can use different functions in the formula builder for doing the calculations.

    variables

    Variables are a way to parameterize a BW report. By using variable in the query definition you can allow the user to populate values for different characteristics and thus filter the outcome of the report. Variables are also used for authorisation and linking 2 reports. They are also used for text replacement.

    http://help.sap.com/saphelp_nw04/helpdata/en/5c/8db07d555411d189660000e829fbbd/frameset.htm

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2006 at 09:01 AM

    Thanks manoseelan,

    Can you explain me how to create a RKF, CKF and a variable, step by step literally?I am very new to BEx. so not sure where to click what...

    Will award points...

    Thanks,

    raj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2006 at 09:20 AM

    Hi Vikash,

    Thanks for your explanation. That serves my purpose. I am trying to appreciate your answer by points, ending up in Errors while assigning. However, I was able to assign for manoseelan. I will keep trying to assign you.

    Thanks,

    raj

    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.