Hi. This is my first post as I cannot find an answer among existing
posts. I have a cube with three dimensions, D1, D2 and D3. D1 has 80
unique values, D2 has three and D3 has 15000. All data is in a single
table with columns C1, C2 and C3, that has 15000 rows, one row per
value in C3 (which corresponds to dimension D3). The cube builds just
fine, but when I drag D3 next to D1 (D2 is across the top), the cube
won't complete the refresh. I think it is doing a product of D1 and D2
(or 80 x 15000). Is there some other way I should be structuring this
to get better performance? TIA.

You're talking only about dimensions. Where are your facts/measures?
There's nothing to display if you don't have measures.

Regards,

Jörg

Regardless of the measure, yes you are doing a cross of 80 x 15000......

OLAP is generally used for analysis and I would suggest either adding more
levels to your 3rd dimension to break up the structure or report directly
from the relational source.

This sounds more like reporting than analysis in it's current form.

ya


"sim" <jmenker (AT) muenster (DOT) de> wrote

You're talking only about dimensions. Where are your facts/measures?
There's nothing to display if you don't have measures.

Regards,

Jörg