Saturday, April 20, 2013

[SQL Server Data Warehousing] Star Schema modeling on Order Header/Details data


In my situation I have a Order Header which contains info like order date, expected ship date, expected arrival date, vendor, buyor, etc... and that is my PO dimension.  I have an Order Detail that contains the line items with qty and cost.  I have a Receiver Header that includes receipt date and receipt status, and I have a Receiver Detail that includes qty and cost of received goods.


For Orders I calculate things like Avg Lead Time, Fill Rate %, and show current On Order.


Depending on how you handle your accounting, a discount that is applied to an order and NOT the line items on the order can skew your margin reporting.  If I had that situation, I would likely allocate the order-level discount to the cost of the line items on a pro-rata basis.




.

social.technet.microsoft.com/Forums

No comments:

Post a Comment

Search This Blog