Order Line Details and Order Status Dimension

View previous topic View next topic Go down

Order Line Details and Order Status Dimension

Post  simmo2013 on Tue Nov 05, 2013 2:17 am

Hi All,

Am thinking best way to model my orders fact table. The grain is one line for every line item on an order. However due to the fact we need to track an order as it is raised, processed and despatched or cancelled we will use a status dimension and then add a new row for every change in status as well. I will then create a degenerate dimension for order number. However this is going to be a huge table with around 20 million rows per year and around 5 years of data. My questions are:

1. how do I calculate number of line items per order?
2. Is my design optimal for this volume of data?
3. will I need to use distinct count (I will be using SSAS) and is this optimal at this volume of data?

Any help advice very much appreciated.

simmo2013

Posts : 6
Join date : 2013-11-05

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