Skip to Content
0
Former Member
Sep 24, 2008 at 08:34 PM

Copy and Save New Record from Actual Cube to Planning Cube in BI IP

66 Views

Hi,

I am trying to Copy Plann Plann data from Actual Cube to Plan Cube Using MultiProvidre (through Aggregation Level).

Based on the below link i was able to Achive to some extent but at the end i am facing problem ,where the copying part comes into picture.

Link:[first-steps-planning-with-multiprovider]

My Scenario is

Actual Cube : Comp Code , Profit_Ctr, Material, Unit, Version, Fiscal Period/Year. Key Figure : 0Quantity.

Plan Cube : Comp Code , Profit_Ctr, Material, Unit, Version, Fiscal Period/Year. Key Figure : 0Quantity.

I Created Multiprovider on these 2 cubes.

MultiProvider: Comp Code , Profit_Ctr, Material, Unit, Version, Fiscal Period/Year. Key Figure : 0Quantity.

And created Aggregation level on MP with all Infoobjects Selected.

Also Created an Input Ready Query as discussed in this

Link:[first-steps-planning-with-multiprovider]

I am able to get the Input Ready cells for Resticted Key Fig Plan Quantity ( Fiscal Period/year , InfoProvider, Value Type, 0Quantity).

Now how do i save the data to Plan Cube from Actual cube with the new value entered in Plan Quantity (which is input ready cell).

Please give me suggestions on this scenario.

Thanks,