Forum Discussion
Data Model Feedback
CB13 ,
I'm afraid in the current data model, you can't achieve this goal. The only way is as you said, to create 3 copies of owner table and build relationship between those copy table and Visit, Test and Item table.
Regards,
Jimmy Tao
If you're using the final example it should work well if you're using a double crossfilter direction in your relationships between the facts tables.
The other option is the merge all three tables together in the query editor.
/ J
Hi,
The final example is what I am currently using - but it doesn't allow me to link on Owner ID directly to the Visit and Test tables. Since the owner's vary this is important:
It feels like I may have to create 3 "copies" of the owner table, 1 to join to each, but this feels wasteful, especially since this is a simplified example and in reality I will likely have several more tables that need this same information.
I'm not sure what you mean by join the tables together in the data model. Wouldn't this then create a lot of additional data fields with repeated data - meaning that all of the Visit data would be repeated at the Item level, over and over again? This also feels ineffecient?
CB13 ,
I'm afraid in the current data model, you can't achieve this goal. The only way is as you said, to create 3 copies of owner table and build relationship between those copy table and Visit, Test and Item table.
Regards,
Jimmy Tao