You can see your Dimensions but not your Measure Groups

July 12, 2009

tags: , , , ,
3 comments

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.

Add comment
facebook linkedin twitter email

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

3 comments

  1. AminJuly 18, 2009 ื‘ 8:08

    very nice tip!
    I read about the importance of existing calculate command within this part before, but I couldn’t answer this problem when I read this post before I read the answer. I completely forgot this tip ๐Ÿ˜‰

    thanks

    Reply
  2. Johnb816May 4, 2014 ื‘ 18:51

    When I originally commented I clicked the Notify me when new comments are added checkbox and now every time a comment is added I get 4 emails using the same comment. Is there any way you may take away me from that service? Thanks! degbaecdfafe

    Reply
    1. Ella Maschiach BIMay 9, 2014 ื‘ 22:10

      I’m sorry John, but this is out of my reach. This is controlled through the blogging platform of Microsoft and is not managed through my own blog. I tried looking it up for you online, and this is the best i could find:
      http://office.microsoft.com/en-001/outlook-help/unsubscribe-from-an-rss-feed-HA010024271.aspx
      Hope that helps,
      Ella

      Reply