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

Changing Fact for Order Modifications

3 posters

Go down

Changing Fact for Order Modifications Empty Changing Fact for Order Modifications

Post  kangaroo Wed Apr 21, 2010 3:40 pm

I've been asking a lot of questions on the forum and have been receiving great help. I don't want it to seem as though I'm taking advantage of this help, but I'm really stuck here.

Business users want to see, in (near) real-time, how its online store is doing. Due to the business of this online store, it may take months to fulfill an order. Furthermore, modifications are quite common. I want to create an order line item fact table, where each row represents a line item of the order. The problem I'm seeing is that the user may modify their entire order such that each line item is completely different (and the user may select more or fewer products). This would mean that on an order status change, I would have to delete all the fact records for a given order ID and then reload the fact table with the new order id line items. Is deleting and then re-adding fact table data the correct way to handle such modifications? If not, are there any suggestions on how to fulfill this requirement -- or is this type of requirement not appropriate for a data warehouse, since its goal is to replace an existing operational reporting system)?

The implication would be that report numbers run off of future fulfillment dates could change, but the numbers for already fulfilled orders should remain the same. Is this acceptable in a data warehouse?

Note: another reason for replacing the operational reports with this system is that this system combines data from multiple sources.

kangaroo

Posts : 8
Join date : 2009-12-09

Back to top Go down

Changing Fact for Order Modifications Empty Re: Changing Fact for Order Modifications

Post  ngalemmo Wed Apr 21, 2010 4:05 pm

If this order system was something cooked in-house, I would try to push back a bit. A well designed order system retains a consistant identifier for an order line and does not reuse them. If a line is added to an order, it is given a new number, lines that are deleted are usually flagged as such or their quantities are set to zero. Having a source like this makes maintenace of the facts much easier.

Of course, this also begs the question... do they want order history?
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Changing Fact for Order Modifications Empty Re: Changing Fact for Order Modifications

Post  BoxesAndLines Thu Apr 22, 2010 8:35 pm

I would!
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Changing Fact for Order Modifications Empty Re: Changing Fact for Order Modifications

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