Showing posts with label Star Schema modeling on Order Header/Details data. Show all posts
Showing posts with label Star Schema modeling on Order Header/Details data. Show all posts

Sunday, April 28, 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

Friday, April 26, 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

Wednesday, April 24, 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

Monday, April 22, 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

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

Search This Blog