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.