"Avoid defining measure groups with zero dimensional overlap" how to add overalp?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » "Avoid defining measure groups with zero...

"Avoid defining measure groups with zero dimensional overlap" how to add overalp?

Rate Topic

Display Mode

Topic Options

Author

Message

grasshopper26

Posted Monday, October 29, 2012 6:30 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, April 12, 2013 7:53 AM
Points: 16, Visits: 108

I am newbie to SSAS

I am trying to understand the following sentence from SSAS cube i just built

"Avoid defining measure groups with zero dimensional overlap" How can i add overlaping dimensions ?

Post #1378217

robert.gerald.taylor

Posted Monday, October 29, 2012 1:41 PM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 2:31 AM
Points: 733, Visits: 781

grasshopper26 (10/29/2012)

I am newbie to SSAS

I am trying to understand the following sentence from SSAS cube i just built

"Avoid defining measure groups with zero dimensional overlap" How can i add overlaping dimensions ?

I think what it is saying is that you want all measure groups to have some conformed dimensions -- that is dimensions that are used in common. That way you can analyze between the measures. A date dimension is a very common dimension that could/would be used on your different measures.

Take a look at:
http://msdn.microsoft.com/en-us/library/bb630266(v=SQL.105).aspx
http://smdbi.blogspot.com/2009/05/what-is-conformed-dimension.html

HTH,
Rob

Post #1378443

« Prev Topic | Next Topic »

Permissions