Resolved: what is the difference between ship date and Due date?
I built a relationship between DueDate (in fact_InternetSales) and Date (in dim_Date) and I have different results, Please could you explain why you decided to choose ShipDate instead of Duedate?
1 answers ( 1 marked as helpful)
When you have an order in your system you have a threshold of send it to the customer within let's say 3 business days. Due date is the absolute latest date that you should ship your order and ship date is when you have actually dispatched the product. Different dates will result in different results