Hi,
I pretty new to optimising AS queres and wondered if there's a way to
force an aggregation for TopCount queries. i've played with setting
aggregations at certain levels which is great, however the key reports
my users run are Top 200 reports which I can't get to perform better.

What can I do to improve this. I've heard that you can manually create
custom aggregations but I'm not sure how to do this.

Many Thanks,
Peter

I don't think you need to go to the effort of manually creating aggregations
- usage based optimisation plus the usual performance optimisation tricks
like partitioning should be what you try first. Have you read the Analysis
Services Performance Guide?
http://www.microsoft.com/technet/pro.../ansvcspg.mspx

If you provide some more details about your cube and environment
(dimensions, calculated measures, client tools used etc) and the kind of
performance you're getting then I might be able to suggest other things to
try too...

Regards,

Chris

--
Blog at:
http://spaces.msn.com/members/cwebbbi/


"Peter" wrote: