Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

StarSchema datamodel

Hi Community,

PFA

I am Developed one application but i want starschema datamodel

Please any one can help (Starschema datamodel,)

Thanks in Advance..

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

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

4 Replies
Highlighted
Specialist II
Specialist II

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

Highlighted
Not applicable

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.

Highlighted
Specialist
Specialist

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

Highlighted
Specialist II
Specialist II

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

ClaUdio and Saumya...