Showing posts with label aggregations. Show all posts
Showing posts with label aggregations. Show all posts

Friday, February 24, 2012

Cube aggregations stop unexpectedly

I am trying to design agreegations for all the partitions of my MOLAP cube. The aggregation calculation process starts but stops at 2% performance (about 20MB).

I have tried to re-argregate so many times by selecting all the options :-

Estimated Storage reaches (100 MB) /
Performance gain reaches (30%)/
I click Stop

But, in all these cases it just stops at 2%. I cannot understand why? And its not one particular partition. Rather all the partitions (eight of them) stop at 2%. There is enough free hard disk space as well (27 gb)

Any, clues could be of great help. Thanks.

Any idea from the MS Analysis services group?|||

The problem is that not all attributes are considered during aggregation design.

Try creating more user hierarchies. Try marking cube attribute AggregationUsage property as Unrestricted.

Hope that helps

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

Cube Aggregation

Simple question about OLAP Cube? Once the dimensions and cube are designed, when we process the cube, what aggregations are stored in the cube. Does the cube aggregate function defined in the measures like AggregateFunction: SUM, COUNT or is it more than that.
Another question—if the user wants to define there own aggregated function, say for example a statistical function such as standard deviation (STDEVP a MDX function) and wants to store the aggregation of that in the Cube while processing, is that possible?

SQL Server 2005 Step-by-Step has a good walk-through on aggregation design. I believe this is in Chapter 7. Basically, you can access the aggregation wizard on the Partitions tab of your cube designer. There's quite a bit to aggregations so, again, read that chapter to get the broader picture.

Regarding STDEV or STDEVP, I believe the MDX function could be used in a calculated member to give you what you are looking for. However, it's not clear to me if it calculates the data at the level of the set you specify or if it performs the calculation across the leaf level members. Either way, you could run into an issue with calculating standard deviation across aggregated data. I recommend you assemble the components of the formula yourself, stored those as part of the cube, and perform the final calculation in a calculated member.

B.