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.