Question:
Hello All
I have the following requirement to copy actual data which is in actual cube to a plan cube which is a transactional cube.
I have done the following created a planning area and level for the actuals cube, created a planning area and level for the plan cube.
Now I want to copy the data from actuals cube to the plan cube I am not sure how to proceed now. I have 4 characteristics and 3 key figures in the actuals cube and the same structure for the plan cube as well.
Please advice how I can proceed to copy from the actuals cube to the plan cube. Also, the next step is while copying from the actuals to the plan the user will specify for each key figure what value to multiply and I need to process the records and multiply by that factor.
Please kindly advise how I can implement this scenarios.
We are running BW 35
Thanks
Charlotte
Answer:
Charlotte,
Create a multi area & include both actual & plan areas in this multi-area.
next, create a level in multi-area & use COPY planning function in this level.
to process the records, create a FORMULA funciton & write necessary code that does the required need.
finally, create a planning sequence & include both COPY & FORMULA functions in this sequence.
hope it helps.
Answer:
Clemson - Many thanks
Charlotte
Answer:
Hi Clemson
Thanks for the update. But while copying I do not want to just copy what I want to do is the data in the cube is last year budgets I want to take them and copy same key figures but change fiscper from say 004.2004 to 004.2005.
Please advise how we can change the characteristics. Also, when they copy I want to provide a flexibilty for the user to be able to select which values to copy from fiscyear - 2003 or 2004 or 2002,etc.
Thanks
Charlotte
Answer:
Charlotte,
to change the fiscper, create a REPOST plannning function & include fiscPeriod in "Fields to be changed" & include this REPOST funciton in planning sequence after COPY & FORMULA funcitons.
to give flexibility for the end user to copy only selected fiscYear, Create a CHARACTERISTIC variable on FiscYear & include this variable in the planning folder & also restrict the planning level with the same variable.
hope it helps.
Answer:
Thanks - Clemson
Answer:
Why can't we use a Variable in the Planning level for fiscal year and a function for copy where fields for change will include fiscal year.
So we can avoid repost function and have copy function do it all.
Thanks - Clemson