Copy Formula Questoin

[sap_cohort]

Hi, I am looking to copy my Actuals to my Budget. I need to select the actual data using some characteristics that are not available in the Budget InfoCube. Is it still possible using formula to copy from one cube to another when the target does not have the same characteristics? Thanks for the help...

[Former Member · Accepted solution]

Hi,

I guess you want to write a copy function on a multiprovider which includes both Actuals and Budget Infocube.In such scenario you might have taken all the characteristic from both the cubes,where you may also have some characteristic specific to only one cube.Assign the characteristics in the multiprovider with respect to there infocube.

you can use formula to copy from one cube to another when the target does not have the same characteristics.In this case it will be represented by # as good as null value.For example if you have costelement,WBS in Actual cube and you have only WBS in budget cube then the syntax will be as follows:-

{KYF,WBS,*#*,Budget} = {KYF,WBS,Costelement,Actual}

Also pls note that all the keyfigure value will be aggregated for that characteristic ,what i mean is suppose i have 3 costelement with kyf value as follows:-

WBS1,CC1-- 100

WBS1,CC2--100

WBS1,CC3--200

when it will be copied with the fox syntax specified above ,it will as follows in budget cube

WBS1---400.

Regards,

Indu

[sap_cohort · Accepted solution]

Yes, this does seem like what I am looking to do. Thanks for taking the time out to provide details as you have. Greatly Appreciated!