Fact Table help Purchase Orders

Hi,

I am trying to create a Fact table based off our Purchase Orders.

The problem I have is creating the field "Total Value" (QTY * LOCAL UNIT COST), my purchase Order detail table has a Product in two separate order lines but at different LOCAL UNIT COSTS, don't ask why but the purchase order line table can be changed after the order has been placed. So any ideas what you would do for a Total Value, what would the Fact Table actually show or what fields should I be showing?

Thanks

Hi,

how many types of LOCAL UNIT COSTS ca be three for a product. What is the differance in different costs. If you are intrested in the multiple cost then it is bettter you capture both the cost.
You need to check how a customer is going to be billed, may be you are intrested on that cost.

thanks

Himanshu

Not sure what your question is. It is typical that facts contain a quantity and an extended amount (quantity * cost/price/whatever). Including a unit value is optional, but that column is non-additive.
It is not clear what the issue you have with different costs for the same product on different rows. It doesn't affect the calculation of total value.