Skip to Content
Former Member
Jan 26, 2012 at 01:44 AM

How to copy actuals data to planning for the chars. not in Aggr. level


Hello experts,

We are doing Tax planning and for that we have created a Multiprovider on two cubes (Actuals and Planning), on the MP we have created aggregation level and Input ready query on the aggregation level.

Because of using MP our planning cube will be empty and data will be fetched from Actuals. We have some 50 characteristics in our cube. But in our aggregation level we have included only 10 characters from the cube ( as only we are doing planning on those).

Now, while saving the input values from the manual planning, we need to copy those remaining 40 characteristics data from Actuals cube to Planning cube by matching the planning values from query.

Is there any possibility to copy characteristics using Planning function/Fox formula which is not available in aggregation level form one cube to another. (i.e: I dont want to use a infocube read FM explicitely and copy the data, as that will affect the performence).

Please through some light on this.