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.