Post reply

Measure Group Is Empty

  • October 21, 2010 at 10:12 am

    #242019

    Hi,

    I have added a new measure group to an existing cube. The new measure group shows no data. When I queried it in Management Studio, it has the data. Also, the data exists in Explore Data of the Fact Table.

    Tried : I checked with the attributes and the role. Created a new measure group by deleting the existing one and processing it before creating. Still, No data.

    Pls throw some light. Thanks.

  • October 21, 2010 at 3:02 pm

    #1240611

    Did you query the cube in Management Studio using MDX or the fact table in the database using SQL?

  • October 22, 2010 at 6:46 am

    #1240863

    Thanks dealdas for the reply.

    It worked now. Basically, I had a wrong relation established between the dimension and the fact table. So, I deleted the fact table again along with all the related dimensions. And then created the Measure group alone. Then it showed. On top of it, I tried with the relation I needed with the dimension.

    By Trial & error method, I got what I needed.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply