Forum Discussion
warehouse views performance in semantic model
I would suggest creating a composite model of the two columns in both your fact table and your dimension table here. I will then bring this data into your semantic model and create the join on the composite model in the semantic model. This should allow a great performance within the semantic model and not having to worry about the views in the Warehouse
I would suggest creating a composite model of the two columns in both your fact table and your dimension table here. I will then bring this data into your semantic model and create the join on the composite model in the semantic model. This should allow a great performance within the semantic model and not having to worry about the views in the Warehouse
Thanks for your response. I realized I've made a mistake in my question, so I've corrected it. What I need really is to make a relationship between a column in the dim to two or more columns in the fact. Thanks for your help.