Copy CKF into KF

[Anand71]

Hello SAP Guru,

It is possible to copy calculated key figure into key figure?

Please let me know what is the fox formula I have to used to copy calculated key figure into key figure and save back into cube.

Thanks in advance.

With regards,

Anand Kumar

[Former Member · Accepted solution]

Hi,

As per my understanding calculated keyfigures are based on some formula or calculation which is been populated during runtime in query.

I guess there is no such methodology by which you can write direct calculated values to keyfigure,you can use FOX to derive the same values based on some calculation in fox and then can assign to specific records for keyfigure.

[Anand71]

Thanks

[Soulsurfer]

Hi.

You can use inverse formulas in your bex-query - http://help.sap.com/saphelp_nw70ehp2/helpdata/en/49/db8d1bc2245d5de10000000a421937/frameset.htm

Using them you can enter values into CKF and inverse formulas will set rules to save result into usual KF.

[former_member5472]

Hi,

You can use FOX only for generic key figures defined in cube structure and not CKF.

Why you want to use FOX for copying from one key-fiure into CKF. You can do the same at qery level itself ..

What kind of manupulation is required in FOX ??

Thanks

Pratyush