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

Purchase Orders Fact Table Design

Go down

Purchase Orders Fact Table Design Empty Purchase Orders Fact Table Design

Post  a.hajjat Mon Apr 22, 2013 10:58 pm

I need to build 2 fact tables the first is open purchase orders loaded from daily open purchase orders table daily,
the second is closed purchase orders loaded from master purchase orders weekly,
Also I have requirment to show the next 3 comming quantity and dates of open purchase orders by SKU
is having view as calculated fact table based on open purchase orders fact table the best approach to solve this?
any better idea?


Posts : 4
Join date : 2013-04-22

Back to top Go down

Back to top

- Similar topics

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