Cube is showing empty

Question

My cube is showing empty suddenly. Even after processing, it is not getting any data. I see while process, it is able to read data from backend. However it is showing no data suddenly. Any idea?

Answer 1

Hi Mani,

It's strange but you probably can see data is there in DSV, views and in the underlying tables (source to cube) or not. Try to do FULL process again and see if it works.

Thanks,
Santosh

Answer 2

Go to the Calculations tab in the cube editor in BIDS, and check that the first statement in the MDX Script is:

CALCULATE;

If you've deleted that by accident, for example while editing other calculations, then the cube will seem as though it has no data in it. The data is there, however, but only at the very lowest level of granularity and it isn't being aggregated up.

HTH,

Chris

---

Blog: http://cwebbbi.wordpress.com/ Consultancy: http://www.crossjoin.co.uk/

Answer 3

Thanks Chris for your help. It has fixed the issue. By mistake we have deleted the CALCULATE command.