0 Replies Latest reply: Feb 22, 2016 10:26 PM by Felix Wong RSS

    cross fact table anaylsis

    Felix Wong

      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 muchDataModel.png