Fact Table help Purchase Orders

View previous topic View next topic Go down

Fact Table help Purchase Orders

Post  dw_viper on Thu Sep 11, 2014 1:25 pm

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

dw_viper

Posts : 2
Join date : 2014-09-11

View user profile

Back to top Go down

Re:Fact Table help Purchase Orders

Post  hkandpal on Thu Sep 11, 2014 2:10 pm

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

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

Re: Fact Table help Purchase Orders

Post  ngalemmo on Thu Sep 11, 2014 8:48 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Fact Table help Purchase Orders

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum