5 Replies Latest reply: May 18, 2014 3:56 AM by Joseph Musekura RSS

    Snowflake model - modeling

      Hi Experts,


      I am very much new to QlikView.  I have a following scenario.


      1 FACT table , 1 Main Dimension , 3 sub dimensions


      Main Dimension Vs FACT - 1:N

      Main  Dimension Vs 1st Sub Dimension-  1: N

      Main Dimension Vs 2nd Sub Dimension - 1:N

      Main Dimension Vs 3rd Sub Dimension - 1:N


      How can i join these tables in my design?  I am trying following -

      FACT LEFT JOIN  Main Dimension

      LEFT KEEP 1st Sub Dimension

      LEFT KEEP 2nd Sub Dimension

      LEFT KEEP  3rd Sub Dimension


      Please advise on my design.