Skip to Content
0
Former Member
Mar 01, 2010 at 12:01 PM

Cube design, too much data detail ?

15 Views

Hi guys,

we are trying to design a cube, and, because of the user requirements of the data detail, we will have to load aprox. 9 milion of entries for every month. I 've never worked with this amount of data (my max is 2.5 or 3 million for year), for me it seems too much data detail for a cube.

We will use aggregates and partition, but still, it's 9 million entries for month. Have you worked with cubes with these amount of data ? Query times were acceptable ?

Thanks in advance.