SSAS - Message group has zero dimensional overlap

It is always better to have seperate cube for each measure group if there are no common dimension between them. But if you have added multiple measure group in same cube and not added the common dimension in the dimension usage, SSAS gives warning message " The measure group has zero dimensional overlap with all of the other measure groups in the cube. Consider moving it to the seperate cube"

To demonstrate this, I have created cube with internetsales and internetSalesReason from AdventureworksDW database. Initially there are no common dimension and so I have received the error as showned in Fig 0.1.

Fig 0.1







There are no common dimension between the measure group InternetSales and InternetSalesReason as shown in Fig 0.2

Fig 0.2















In order to avoid this issue, we can have common dimension between these two tables by adding SalesOrderNumber as cube dimension. SalesOrderNumber is actually saved in InternetSales table itself which is a fact table and so to have this field as dimension, we need to create fact relationship.

Click on the Add dimension option from Dimension usage tab and select FactInternetSales from the list to add InternetSales as dimension.
Fig 0.3



















Once you add this, you can see the dimension usage tab with common dimension.















Previous Warning/Error message also disappears once this common dimension is in place.


Comments

  1. This blog is very helpful for beginners and experts also, thanks for sharing it. Keep share content on MSBI Online Training Hyderabad

    ReplyDelete
  2. This blog gives very important info about bi Tools Thanks for sharing, learn more about BI Tools like Tableau Online Course

    ReplyDelete
  3. Learn tableau in a best possible way with the help of tableau practice tests

    ReplyDelete
  4. Through this post, I know that your good knowledge in playing with all the pieces was very helpful. I notify that this is the first place where I find issues I've been searching for. You have a clever yet attractive way of writing on Msbi online training

    ReplyDelete
  5. Great Article Cloud Computing Projects

    Networking Projects

    Final Year Projects for CSE

    JavaScript Training in Chennai

    JavaScript Training in Chennai

    The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete

Post a Comment

Popular posts from this blog

Microsoft BI Implementation - Cube back up and restore using XMLA command

Databricks - incorrect header check