Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Cube Aggregation

Author  Topic  blizzard Starting Member 1 Post Posted - 2007-08-20 : 19:23:41 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?