How to deal with shared dimensions between two models

[AmiraBedh]

I have two Azure Analysis Services tabular cubes :

ObjectifEntity cube contains :

• DimEntity
• DimYear
• DimCountry
• FactObjectifEntity

ObjectifEmployee cube contains : 

• DimEmployee
• DimYear
• DimCountry
• FactObjectifEmployee

We can remark here that DimCountry and DimYear are shared dimensions between the two cubes and in my case I found my self importing them twice. I am using a composite model like mentioned here.

Is it possible to import them once with the ObjectifEntity cube and then link them to FactObjectifEmployee which is in another cube coming from a different datasource? Does it have any impact on the reports performance?

[parry2k · Accepted solution]

@AmiraBedh with the recent update, once you have the first dataset loaded when you select the 2nd one, it allows you to choose which tables you want, you can unselect the common dimension and only bring the one you need, and then create a relationship between single dimension to the 2nd fact table. 

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!