I had created usage based aggregations on Analysis server 2000 cubes. But this does not improve the performance. Would you please let me know key points to consider while creating usage based aggregations?
http://www.sql-server-performance.com/wp_msas_3.asp http://www.sql-server-performance.com/wp_msas_3b.asp Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.