Question:
Hi I have an infocube which I have loaded data into.
I have checked the infocube contents through manage infocube and the data has been loaded.
However I am running a simple query and when run the query says "query delivered an empty results set".
Any ideas on what the reason could be??
Regards,
BW babe
Answer:
is the data 'ready for reporting' (= is there this blue&yellow icon in the 2nd column of request list in the manage of the cube?)
Answer:
no there is no icon?
please advise.
best regards,
bwbabe
Answer:
Can be many reasons for that (techincal problems, aggregates not rolled-up, ...)
My first guess would be that your aggregates are not rolled up (go to 2nd pane in the manage of the infocube to roll-up manually).
If you don't have aggregates: search the forum with 'ready for reporting', select 'all terms', on forum Business Warehouse, and i'll bet that your scenario has already been solved in one of these topics.
Answer:
thanks for putting me in the right direction.
Basically there was some failed requests previously that was holding the good load up.
Not sure what the correct procedure is here but I deleted the incorrect ones and changed the status of the others from orange to green.
It worked though.
Thanks
bwbabe