1 Reply Latest reply: Mar 25, 2013 9:37 AM by Miikka Koskinen RSS

    I am new to BI and qlikview

      This is my first post as a Qlikview BI Student. I have read so many content about data warehousing and their structures,  OLAP,star schemas, snowflake schemas, fact and dimension tables e.t.c  I have also practised the online lectures. I quite understand what BI and BW is all about. I also understand that a cube can have more than one fact table.  I have this relational database model  which is i got from one of the qlikview online tutorials. I would be happy if anyone can convert the relational model to a star schema model. I don't mind if you provide more variations of the star schema , such as modelling it to have more than one fact tables. Please click on the image below to see a bigger version. Thanks.

       

      data schema.PNG

        • Re: I am new to BI and qlikview
          Miikka Koskinen

          Hi!

           

          Write script like this (pseudo code):

           

          Fact:

          Load *

          From Orders;

           

          Join

           

          Load *

          From OrderDetails

           

          Join

           

          Load *

          From Shipments;

           

          Join

           

          Load *

          From Shipper;

           

          Customers:

          Load *

          From Customers;

           

          Join

           

          Load *

          From Division;

           

          Products:

          Load *

          From Products;

           

          Join

           

          Load *

          From Categories;

           

          Load also calendar, offices, employees and suppliers. Maybe you can map suppliers to fact -table. You can also join offices and employees.

           

          Above will produce reasonable star schema.