Forum Discussion
Fact and dim join in Semantic Model
We are trying to join a fact table to multiple dimension tables. Issue we are facing is semantic model does not allow multiple join between these fact and dim tables. It allows only one key column jo...
hello Anonymous
Instead of creating a concatenated key directly in the semantic model, incorporate a surrogate key in your ETL process. This key is built by combining the multiple natural key columns you need and then stored as a single column in both the fact and related dimension tables. This simplifies join definitions and maintains performance.
If this is helpful please accept the answer
Hi Anonymous
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.