is a MDX madman.
He took a simple query in MDX that took 1 minute and 20 seconds and optimized it down to happening instantaneously. The best part is that he walks you through each step of the way as he incrementally optimizes it. First attempt was strait MDX, then he went through and added a Stored Procedure with a custom C# function. Finally he resorted to using an ordered Named Set. Each step detailed why it took so long and explained what was happening under the covers of Analysis Services 2005. Bottom line is that this is a great post
, and I thought it was very blog worthy.
If ranking tickles your fancy, check out this free
chapter excerpt on Sorting and Ranking
from MDX Solutions, 2nd Edition