What is the best way to manage dynamic connection tables?

[aicms91]

Hi all,

I have two different dim_tables (one from ERP and another from external market data) and would like to create a connection between both. This connection would only be for a specific set of products but they are written in different ways (e.g.: one product is in english and other in portuguese). To manage this, I was thinking of creating a table that connects only these products and then connect this table to each dim_table. Example:

ERP_Dim         Ext_Dim

Product A  >   Produto A

However, these might be dynamic as both tables might have new values to add/change each month.

What do you think is the best way to manage this situation?

Do you usually resort to excel, by creating a table and managing it outside PBI? Do you create a new table in PBI and manage it there? Do you use any other tool and connect it to PBI? 

Thank you!

AS

[amitchandak]

@aicms91 , These dim should join to fact and you can switch based on language using field parameters or bookmarks

[aicms91]

@amitchandak thank you! Although these are useful, I'm not sure if they solve my issue. The relationship with the fact_table is clear and field parameters/bookmarks too - but I'm not sure if they apply here.

How do you manage these regular dimension tables connection and updates?

[amitchandak]

@aicms91 ,
Can you share sample data and sample output in table format? Means how you want to use that.  I will try to solve