Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Fact Table help Purchase Orders

3 posters

Go down

Fact Table help Purchase Orders Empty Fact Table help Purchase Orders

Post  dw_viper 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

Back to top Go down

Fact Table help Purchase Orders Empty Re:Fact Table help Purchase Orders

Post  hkandpal 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

Back to top Go down

Fact Table help Purchase Orders Empty Re: Fact Table help Purchase Orders

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

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

http://aginity.com

Back to top Go down

Fact Table help Purchase Orders Empty Re: Fact Table help Purchase Orders

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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