Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik community,
I have an App with two separate FACT tables using same dimensions, but are loaded twice (e.g an employee dimension table is loaded two times, one for FACT1 and one for FACT2). This avoids circular reference.
According to Kimball data warehouse, FACT tables can be drill across using conformed dimensions. In this case, is there a method or strategy I can implement to drill across my two FACT tables? What is the Qlik way of doing this?
Thanks.
Like previously already suggested the recommended data-model is a star-scheme with a single (horizontally + vertically merged) fact-table. Probably there are ways to sync multiple fact-tables and associated multiple dimension-tables, but it will have various side-effects in regard to the development-efforts, performance und usability. Therefore, why doing simple things much more complicated as needed ...
- Marcus
Hi Marcus, thanks for the reply.
I understand your point, but due to reason I need to understand this too. Besides the the method you suggested, I will like to know these alternatives (even if it's complicated). This will allow me to have more flexibility. 🙂
Right now I have two stars, and they are not associated as I have loaded duplicate dimensions to these facts to avoid circular reference.
For me there are a lot of reasons to use a star-scheme, for example:
- Marcus