Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

"Avoid defining measure groups with zero dimensional overlap" how to add overalp? Expand / Collapse
Author
Message
Posted Monday, October 29, 2012 6:30 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Monday, October 29, 2012 1:41 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 03, 2014 6:23 AM
Points: 1,135, Visits: 1,149
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 »

Add to briefcase

Permissions Expand / Collapse