Guys, currently I have recreated a link table for all of my fact tables so that perform analysis by either time or staff information. However, now I encounter another issue. If I want to perform analysis across 2 fact tables, I just can't.
For example, data in MDM_REG is about users using our mobile solutions, and data in APP_install is about our self-develop APPs usage. If I want to check how many users who have install a specific APP, and also running iOS 9.2, I can't sort that out in the Link Table.
Is there any way I can do, but also without circular reference? Thank you very much