BW Integrated Planning - Copy only query grid data
I'm developing a cost center planning report using BW IP.
My doubt is.
I created a standard copy function and I want to execute this function to copy data (actual to plan version) only for the data previously displayed in the input-ready query. The problem is that the function copy everything from the cube A(real data) to the cube B(plan data).
When the user runs the query for the first time, he/she fill the two characteristics: Year and Cost Center. So, I want the copy function copy data for the new version (user will inform) only for the data already filtered (ex: costcenter: CC01 / Year: 2015).
Does everybody knows how to do this?
Andrey Uryukin replied
Let's say user enters CC and year in the corresponding variables (ZCC, ZYEAR) when he enters the report.
This is your source (real data) restriction.
Then he desides to copy this selection to other cube.
Create a filter where 0INFOPROV is restricted to the target cube.
Create a copy function where fields to be changed is 0INFOPROV, but in conditions select CC and year.
Then, in condition restrict CC and year to ZCC an ZYEAR variables.
Finally, create a planning sequence.
This way you will copy only the data restricted by ZCC and ZYEAR.