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

PASS Presentation "Deep Dive into MDX"

SQL PASS organization holds the Summit 2007 this year in Denver, CO from Sep 17 to Sep 21. I always liked attending PASS summits, but this year I have been honored by the PASS committee who offered me to present at pre-conference seminar on the subject of my choosing. Pre-conference seminars don't have the glory of the conference presentation, because they are, well, pre-conference, so the attendance is light, as most people arrive only to the conference itself. However, the pre-conference seminar runs for whole 7 hours, as opposed to 1 or 1.5 hours of the normal PASS presentation. I always wanted to do a deep presentation on the MDX internals, but it is difficult to do in 1.5 hours only and in the full room with people. But it is so different in a setting where there are only few dedicated people, who are really into MDX (otherwise why would one choose to pay money to suffer through 7 hours of MDX talk!). I must admit that I am somewhat nervous about it, because I never presented 7 hours straight before, and it is a lot of work to make such a presentation. If you are one of the people registered for the PASS and you are interested in attending my session, I would really like to know what would you like to hear - there is still plenty of time to make changes to the presentation. And even if you won't attend the session, I would still like to hear the suggestions. You can either leave your suggestions in the blog comments or email them to me. Thanks in advance !

Here is the official blurb

This class is for seasoned MDX practitioners who have mastered “Fast Track to MDX” and who feel very comfortable with “MDX Solutions Second Edition”. We will talk about MDX semantics such as calculation precedence, multiselects, coordinate overwrites, visual totals flavors, arbitrary shaped subcubes and how all that can be leveraged to get MDX calculations to return desired results. We will also discuss important internals such as caching subsystems, query optimizer, execution plans and more. This isn’t a pure theoretical knowledge, we will see how it can be directly applied to optimize performance of MDX calculations. Differences between AS2005 and Katmai (AS2008) will be discussed where appropriate.

Published Tuesday, August 14, 2007 7:07 PM by mosha
Anonymous comments are disabled
Privacy Statement