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.
There are no common dimension between the measure group InternetSales and InternetSalesReason as shown in 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.
Once you add this, you can see the dimension usage tab with common dimension.
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.
This blog is very helpful for beginners and experts also, thanks for sharing it. Keep share content on MSBI Online Training Hyderabad
ReplyDeletenice
ReplyDeletemsbi training in Hyderabad
This blog gives very important info about bi Tools Thanks for sharing, learn more about BI Tools like Tableau Online Course
ReplyDeleteLearn tableau in a best possible way with the help of tableau practice tests
ReplyDeleteThrough 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
ReplyDeleteGreat Article Cloud Computing Projects
ReplyDeleteNetworking 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