Solved: Re: StarSchema datamodel - Qlik Community

qv_testing · ‎2013-10-07

Hi Community,

PFA

I am Developed one application but i want starschema datamodel

Please any one can help (Starschema datamodel,)

Thanks in Advance..

saumyashah90 · ‎2013-10-08

Hi Raju,

What you can do is Left Join "ORDERS","ORDERSUMMARY" and "ORDER DETAILS" based on OrderID and all together you can left join it with "CUSTOMERS" based on CustomerID
.

View solution in original post

qv_testing · ‎2013-10-07

Please anyone can help me.............

Report Inappropriate Content · ‎2013-10-08

Hi Raju,

I would advise you to put the tables "order", "ordersumary" and "OrderDetails" in one. Also assemble the tables "Divisions" and "Custumers" and finally the tables "products" and "categories" in this way you will have a perfect star schema model.

saumyashah90 · ‎2013-10-08

Hi Raju,

What you can do is Left Join "ORDERS","ORDERSUMMARY" and "ORDER DETAILS" based on OrderID and all together you can left join it with "CUSTOMERS" based on CustomerID
.

qv_testing · ‎2013-10-09

Thank U very much.........both

ClaUdio and Saumya...