Some additional observations:

- You can also refer to these resources:

http://www.microsoft.com/technet/pro...ntain/ansvcspg.
mspx

Summary: This paper describes techniques you can use to optimize query
responsiveness and processing performance in Microsoft® SQL Server™ 2000
Analysis Services.
...
http://blogs.msdn.com/bi_systems/
as new questions arise. These postings are shorter and less formal than
white papers and technical articles, and are cross-referenced across
common subject areas. These entries are targeted at common questions
and attempt to offer focused, quick and helpful answers.
...
- Removing intermediate levels of a dimension could degrade query
performance (less aggregations to answer queries)

- Add aggregations based on actual usage pattern

- Optimize cube schema to minimize processing time


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***