BW Integrated Planning - Copy only query grid data

[Former Member]

Hello,

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?

Regards,

Thiago

[Former Member · Accepted solution]

Hi,

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.

BR,

[Former Member · Accepted solution]

Andrey, thanks a lot.

The creation of the planning sequence solved my problem. I was trying to do the copy function without it, but the filter in the planning sequence solved.

Best regards,

Thiago