cancel
Showing results for 
Search instead for 
Did you mean: 

Copy Formula Questoin

sap_cohort
Active Contributor
0 Kudos

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...

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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!

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Kenneth,

In a Single same cube, for the COPY function, you neednot have same characteristics. It depends upon your requirement. While creating the COPY function, you need to mention the Charactristics and Keyfigures from where you are copying and what you are copying. You also need to mention the destination fileds where you want to copy the data.

In your case, while copying data from Actual cube to Budget cube (where the cubes are different), you necessarily have to have common characteristics and keyfigures for which you want to copy. Otherwise system will not display the correct data.

Hope this helps.

Regards,

Poonam