i need to create a report upon a multiprovider contain 3 actuals cube and 2 planning cubes where 1st input variable has to be fiscalyr/period and from the 2nd variable has to get the fiscal period .
suppose var 1(X) =001/2009(april 2009)
var2(y) =003(not static)
then in the report we should get the mentioned fiscal year period from the Actuals and Y periods ago from the planning cube.
so as per example thee report should contain for april and jan(april - 3periods).if Y = 6, then it should be April - 6 periods.
so how to go about it?(in detail)
suppose i make Y variable on fiscal period as customer exit, will i able to access the variable X created over fisalyear/period?if possible how?
In the variable Y customerexit, is possible to restrict the values from planning cube?(how to restric infoprov).