THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Microsoft OLAP by Mosha Pasumansky

Analysis Services 2000 vs. 2005

I have run across a presentation called “Analysis Services 2000 vs. 2005” prepared by Jaimie Basilico and Mark Frawley (Jamie works in Microsoft as Senior Technology Specialist in the East Cost, and he is one of the best field people in Analysis Services that we have). This presentation is targeted towards people who are familiar with Analysis Services 2000 and want to come on speed with Analysis Services 2005. I have found the presentation very useful, but not all subjects are covered in the same depth. Below are my comments
  • Slides 10-11: Good explanation of concept of Data Source Views (DSVs). A little bit overlap with later slides on UDM, since building cube over fact tables with different granularities is really feature of UDM, not of DSV.
  • Slide 12: One-click-cube feature is great to get you started, but you still need to know your schema well
  • Slide 14: Real replacement for Archive/Restore and CAB files of AS2K is built-in engine support for Backup/Restore in AS2005
  • Slides 16-17: UDM overview
  • Slide 18: I think mentioning of XMLA vs. non-XMLA clients and client-side caching is confusing here - especially in the context of previous bullet points. Probably the best would be to remove the last bullet point and discuss XMLA and thin-client architecture separately.
  • Slides 19-29: Great overview of Proactive Caching. Definetely best part of the presentation. Worth every slide.
  • Slides 30-35: KPIs, Perspectives, Actions, Translations - good overview. Wish it was more detailed, like Proactive Caching.
  • Slides 36-44: Dimensions architecture. This is very important part of UDM - Role playing, Fact, Many-to-many, Reference dimensions are covered. Only one correction here - slide 39 - Fact dimensions actually don't do autoexist with other dimensions.
  • Slides 45-47: MDX - this is weakest part of the presentation, changes to MDX could easily fill dozens of slides - presentation doesn't cover any of them.
  • Slides 48-49: Stored procedures and server ADOMD.NET
Published Sunday, January 30, 2005 11:19 PM by mosha
Filed under:
Anonymous comments are disabled
Privacy Statement