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

Order Line Details and Order Status Dimension

Go down

Order Line Details and Order Status Dimension Empty Order Line Details and Order Status Dimension

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

Back to top Go down

Back to top

- Similar topics

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