O Aggregations Designed

[BKhanna]

I tried to design aggregations for my cube using MOLAP storage and 'Performance Gain Reaches 50%', but it tells me no aggregations have been designed when I click 'Start'. When I process the cube, it processes successfully.

What could be causing this?

Thanks.

 

[justins57]

BK,

How are you designing the aggregations? With the Analysis Manager Interface or with the DSO object?

How many dimensions do you have linked to the cube?

Is it possible you don't have any data in your source table or view?

Justin

 

[BKhanna]

I am using Analysis Manager. There are 11 dimensions in the cube. I tried adding dimensions one by one and designing aggregations. I get aggregations with 10 of the 12 dimensions. When I add one of the last two dimensions, it shows 0 aggregations. Both of the last two dims are parent child. When I add each dimension, I save the cube and do full processing.