calculated keyfigures

[Former Member]

Hi,

will the values of the calculated keyfigures in the query stored in the corresponding infocubes???\

[Former Member · Accepted solution]

No Vaishali,

Calculatd key fig and restricted key fig. are not stored in cube. They are calcuated at run time of query.

Regards,

Mahendra

[Former Member]

hi vaish...

1) CFK sand RKFs are not stored but calculated on the fly

2) please refer to datamodeling doc:

help.sap.com/bp_biv133/documentation/Multi-dimensional_modeling_EN.doc

and to several similar questions here in the forums...

3) this can depends from your update rules, for example, or from different report definitions...

4) see point 2 (anyway, this depends from your requirements...in a normal situation, if you have an info available as an attribute of another one, you can decide if you want to "freeze" this info at the loading time or if you need to display this info dinamically (the latest value available in master data...)

Data is not stored by CKF or RKFs these are restriction or calculation on infoobjects which might be holding data in infoproviders.

hope it clears..

all the best....

[Former Member]

Hi Vaishali

The info related to CKF wont stored in the infoprovider they are stored in the

following tables as

The header definition of CKF is stored in RSZCOMPDIR.

The CKF/Formula Elements are stored in RSZCALC

All queryelement header info is stored in RSZELTDIR

Hope itz helps a little..!

Cheers

Kishore M Reddy

***Assigning pointz is the only way of saying thanx in SDN ***

**Learning the thingz is never end process if u stop it will Be a devil if u continue it will be a divine***

> Hi,

>

> will the values of the calculated keyfigures in the

> query stored in the corresponding infocubes???\

[former_member188975]

Hi Vaishali,

The values of the CKF are not stored in the cube. They are calculated during execution of the query.

Hope this helps...