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.

if you talk about Cognos cubes you have to post your question on the Cognos
web site.

if you talk about the Cognos client connected to an AS2005 or AS2000 cube,
then try first to access your cube using Excel and see what's appends.

but 80 * 15000 is a really big result and a cube is not a good solution for
this type of usage. (flat representation of your data instead of "real"
multidimentionnal usage)


"Neo" <S_p_a_m__S_u_x (AT) hotmail (DOT) com> wrote

But I have seen plenty of PowerPlay Cube discussion here, just not on
my specific issue.