Purchase Orders Fact Table Design

View previous topic View next topic Go down

Purchase Orders Fact Table Design

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

Hi,
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?
Thanks
Alex

a.hajjat

Posts : 4
Join date : 2013-04-22

View user profile

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