Skip to Content
0
Former Member
Oct 19, 2005 at 10:00 AM

NO DATA IN REPORT

18 Views

Hi gurus...

We use two cube's for extraction one <b>actual(Current)</b> AND one <b>Plan(Forecast)...</b>

we move some characters of the Plan to the actual cube on a regular basis...

ex:- What ever we have planned for <b>2004(Plan)</b> in the year <b>2003(Actual)</b> we used the version = plan in the Selection of query.

Now we are Using multiprovider based on these two cubes and now I need 2 years past<b>(2002-2004)</b>

; <b>current year(2005)</b> and Future(2006-2009) in the query...

I need to change the versions of Plan to Actual as we get the data of 2002-2004(PAST DATA) from ACTUAL CUBE now...

When I give the Version as Actual and run the Query I see no data in the columns where I have given the Version from ACTUAL...<b>PAST DATA</b> I only see 0,00

But I see the columns filled which is getting data from PLAN:

The infoprovider is the Multiprovider...

The query should be based on the Fiscal year entered by the User in the VARIABLE

Can anyone please help me for the same... what might be the reason and what might be the solution for the same..

Cheers..

Preethu...