December 2005 - Posts

Christmas gift: Excel AddIn 1.5 for Analysis Services 2005

Microsoft released a new release of Excel AddIn for SQL Server Analysis Services: it's the version 1.5 which is compatible with Analysis Services 2005, compatible in the sense that it fully navigates attributes and hierarchies in a meaningful way. Unfortunately, no KPI support (at least I can't find it).

Applied Microsoft Analysis Services 2005

I just received a copy of Applied Microsoft Analysis Services, by Teo Lachev. I have to be honest: I already read drafts of this book through this year because I've been one of the reviewer. As I said to Teo, I didn't realized before that this would've been more than 650 pages long: it's an impressive work and it well covers the fundamental concepts of the new Analysis Services 2005, UDM first!

I will get other books on SSAS (but I'm a consultant and teacher and I have to know what is best to suggest to my peers) but this is a very good entry point, not only for beginners but also for experienced AS2000 developers. After two years of beta testing, I still learned a lot reading drafts.

Now I hope someone will write a definitive "Inside Analysis Services 2005" book, that is the big miss since OLAP Server 7.0 release: I need it, I can't master SSAS without it. Help! :-)

KpiUtil

Microsoft release KpiUtil, a tool that should facilitate the move of KPIs between Business Scorecard Manager 2005 and Analysis Services 2005. It could be useful...