Analysis Services

SP2 is released

You can download it here:
And from the "What’s new in SP2 readme":
For more information about SP2 in the Microsoft OLAP blog by Mosha Pasumansky, see the Additional Resources section on the SQL Server 2005 – Analysis Services page on the Microsoft TechNet Web site.
Mosha, it’s official, you are the new BOL!

Anyway, seriously, as I said on Friday there’s some new stuff in the samples:


The Aggregation Manager is a tool which lets you view, design, edit, and add aggregations based on the information collected in the query log.


The ASTrace utility provides you with the ability to capture an Analysis Services trace and log it into a SQL Server table. The table can then be queried later or read using SQL Server Profiler.


The Analysis Services Upgrade Verification tool lets you compare Multidimensional Expressions (MDX) query results and performance between a Microsoft SQL Server 2000 Analysis Services databases and a Microsoft SQL Server 2005 Analysis Services database. This tools helps you verify that your upgrade from SQL Server 2000 to SQL Server 2005 was successful.

… it looks like there are several new AMO samples. But ASUV – I hadn’t heard about this, but it sounds quite interesting. I’ll have to take a closer look.

Leave a ReplyCancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.