Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qliks,
Need an help to build Star Schema
Order table has orderdate, customer num, cust name, itemnumber, order num, ordered qty.Shipped table has shipped date, order date, order num, item num,item description, shipped qty, cust num, cust name.
How to join them to get :
1. ordered qty vs shipped qty by item description2. Weekly monthly ordered qty vs shipped qty
Any idea is appreciated.
Thanks!
Pooja