Measure Group Is Empty

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Measure Group Is Empty

Measure Group Is Empty

Rate Topic

Display Mode

Topic Options

Author

Message

Ms. V J

Posted Thursday, October 21, 2010 10:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 15, 2012 11:21 AM
Points: 9, Visits: 24

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.

Post #1008634

naveendas

Posted Thursday, October 21, 2010 3:02 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 8:12 AM
Points: 36, Visits: 141

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

Post #1008841

Ms. V J

Posted Friday, October 22, 2010 6:46 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 15, 2012 11:21 AM
Points: 9, Visits: 24

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.

Post #1009135

« Prev Topic | Next Topic »

Permissions