Friday, August 25, 2006 #

MDX Ranking Wizardry

Mosha 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.

posted @ Friday, August 25, 2006 12:40 AM | Feedback (26)