Skip to Content
0
Former Member
Jun 02, 2011 at 02:30 PM

Integrated planning

27 Views

HI Friends

I've the following requirements. I've Cubes C1 and C2 , C1 is real time cube and C2 is basic cube.

Cube C1 have the following infoobjects.

Obj1, obj2, obj3 and Total and variance (Input Ready KF)

Cube 2 have Obj1, Obj2, Obj3 as navigational attributes and amount. Both cubes have fiscal year, posting period.

Now I want to create an IP query in the following format.

Obj1 Obj2 Obj3 fiscalyear posting period Total (Input Ready to enter values) Amount (Cube C2 - Not input ready) Variance.

A1 B1 C1 2011 06 100 50 50(100-50)

A2 B2 C2 2011 06 300 100 200(300-100)

etc.

The variance must save on IP cube as variance .

How could we achieve this. Please through some thoughts on the issue.

Regards,

Charan.