Forum Discussion
I need help with my model
Hello,
I have a star schema, and the tables below connect to the same fields on the fact table however, whenever I attempt to use fields from the two tables, I get "can't display visual" - there is a missing relationship between these fields.
Can someone please explain what the issue is or how to fix it?
Thank you
D
Hello
Sure cos the filter propagation work from 1 to many. When you are using a field from table a the filter is blocked by the many relation. Use the common field from the dimension table
2 Replies
Hello
Sure cos the filter propagation work from 1 to many. When you are using a field from table a the filter is blocked by the many relation. Use the common field from the dimension table
Did i answer you questions? Mark my answer as a solution !