Restricting Forumula key figure with F symbol

[Former Member]

Hi Gurus,

i have a formula keyfigure which i want to restrict with fiscal period can somebody plz guide me how to do it

plz kindly provide me step by steps plz...thanks in advance

thanks and regards

harish

[edwin_harpino · Accepted solution]

hi Harish,

i think you have to create first restricted key figure ('new selection'), right click 'keyfigures' and 'new selection', then choose the basic keyfigure use in formula and restrict with fiscal period, then create 'new formula' using this new created restricted key figure.

for 'calculated keyfigure' that exist in infocube level (in left panel-top), you can directly use for restriction (rkf from ckf).

hope this helps.

[Former Member · Accepted solution]

Hi A.H.P.

First i need to create a Restricted key figure which i want to use in the Formula

am i right once its created i can use that in the calculated keyfigure or formula keyfigure.

am i right but here i am using two key figures in the formula so do i need too create two restricted key figures and then

create the formula using them.

F is for Formula key figure- C.C.

thanks and regards

harish

[former_member188325 · Accepted solution]

<i>First i need to create a Restricted key figure which i want to use in the Formula

am i right once its created i can use that in the calculated keyfigure or formula keyfigure.</i>

yes u r in rght direction.

<i>am i right but here i am using two key figures in the formula so do i need too create two restricted key figures and then

create the formula using them.</i>

i didnt get u ???????u can two kfs in formula without any problem...

how many restrictions u r having on KF?if u r having two different restrictions ,and both are different then u have to go with two restricted keyfigures..then use both restricted kfs in formula...

what are u trying to achieve exactly?

[edwin_harpino · Accepted solution]

hi Harish,

you are right, if it's possible (no percentage from total result etc), i do strongly suggest you to create it as 'calculated keyfigure' and 'restricted keyfigure',

'global' used (not 'new formula' and 'new selection' which's recognized local),

with this you can create the 'calculated keyfigure' first (from 2 basic keyfigure), then create restricted keyfigure from this ckf. (instead of create one rkf by one then ckf).

these keyfigures then also can be used repeatedly in other reports from the same infoproviders.

please follow the links i provided in previous reply. hope this helps.

[Former Member · Accepted solution]

Hi A.H.P.

i am sorry for confusion

Actually i have a formula key figure example A and in this A i am using some keyfigures B and C like B-C so

i want to restrict this A to Fiscal period....so as per my understanding do i first need to

make B and C as Restricted and then use them in A and then automatically A will be restricted by Fiscal period

am i right.

thanks a lot for your help

regards

harish

[former_member188325 · Accepted solution]

yes exactly....u r rght..first u need to restrict B and C with Fiscal year and then use them in A...

and u can't restrict a Formula with some value...

hope this helps

thnaks

[edwin_harpino · Accepted solution]

hi Harish,

yes, with 'formula' and 'selection' you have to restrict first b and c, that's why i do suggest whenever possible do it with ckf and rkf (from left panel), since we can have rkf from ckf and vice versa.

hope this helps.

[former_member188325]

what is F?

[edwin_harpino]

dear Harish,

please follow steps in sap help for how to define selection, formula, ckf, and rkf

http://help.sap.com/saphelp_nw2004s/helpdata/en/f1/0a564ce09411d2acb90000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/71/0aec3b6e011341e10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/61/d0b143aa26b849b4e79a859ea1d7d1/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/13/e072abaddb574284d22361f0b824bf/frameset.htm

@C C, we mean formula for F

hope this helps.