A colleague of mine ran into a peculiar problem with her cube. She deployed it just fine and didn’t get any error messages. Still, there was a problem. She could see the dimensions in her SSAS project just fine. She could see her cube as well. But she couldn’t see any of her measure cubes.
So what was the problem? She was missing the calculate statement from her cube. If you look in the BIDS at your cube on the Calculations tab with a Script View, you’ll be able to see that the first row in there is “Calculate;”
The calculate statement appears by default in the calculations tab of your cube. The calculate statement tell your cube to aggregate the fact data from the lowest level of granularity to the higher levels.
So, if you can’t see any of your measure groups or all your measures return null value, then maybe you should check that the “Calculate;” statement exists in the Calculations tab in your cube.
Last but not least, I’ve recently learned that Dubi Lebel is leaving Microsoft Israel. Whenever I got to see Dubi, he would talk to me about something in SQL Server with the most genuine excitement. And his excitement is very contagious!
Dubi, I wish you the best of luck in your new path.