Monitoring cube aggregations.

Hi All,Can some one explain me the process of monitoring the aggregations created during the cube design are being used while running a MDX , for example aggregations are created during the design process of adventure works DW cube, I would like to verify those aggregations are being used when I fire a query against a particular measure in a measure group for which aggregations are created.Thanks

It is mentioned in Teo Lachev's book (Applied Microsoft Analysis Services p.460):

"You can use SQL Server Profiler to determine if a given query is satisfied from the cube aggregation or not. However the SQL Server Profiler won't tell you why the server has decided to use a particular aggregation. If the server didn't use aggregations, the Progess Report event will show 'Start reading data from the Partition Name partition'. Otherwise the report will say 'Start reading from the Aggregation Name aggregation'."

Hope this answers your question

Christina

|||Thanks Christina,I got the answer from your message.