Home Forums Data Warehousing Analysis Services "Avoid defining measure groups with zero dimensional overlap" how to add overalp? RE: "Avoid defining measure groups with zero dimensional overlap" how to add overalp?

  • October 29, 2012 at 1:41 pm

    #1553889

    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