BEx

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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