Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BW Integrated Planning - Copy only query grid data

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
Former Member replied

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,

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question