I have 3 Cube right now. The names are Demographic, Employment and
Health.

Demographic has 50 Dimension.
I am using same 50 Dimension of Demographic in Employment cube also but
with addition of 70 more.
In Health Cube I am using same 50 dimension of Demographic but also
addition of 70 more.

So I have to process 3 cubes. So you see I am processing Demographic 50
dimensions 3 times. It is adding lots of overhead.


But I have to find a way to have around 300 Dimension in a cube so I
came up with this idea.

Can anybody please tell me if they know any better approach?


Thanks in advance
Sam

does your cubes are into the same database in AS2000?
do you use shared dimensions?


"Sam" <msam77 (AT) gmail (DOT) com> wrote

Yes they are in same AS2000 and I do use shared Dimensions.

Thanks
Sam

Jeje wrote: