THE SQL Server Blog Spot on the Web

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

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

MDX best practices analysis using MDX Studio

Mosha released a new version of MDX Studio (0.4), which offers an "MDX Analysis" function that suggest best practices for a given MDX query.

I tried the tool with some MDX query and it offers very good suggestion (when possible with link to further information about the issue) for both the MDX beginner and the MDX veteran. Sometime, the suggestion cannot be applied because you really want to make a particular "slow" calculation, but in general the approach is pretty good. A further step would the a "pluggable" architecture to extend best practices rules, just as FxCop does. However, chances are that not so many peopla have the time to implement additional rules, so it could be a useless effort and Mosha's time would be better spent on extending existing rules in the future.

Published Sunday, July 20, 2008 1:19 PM by Marco Russo (SQLBI)
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



miky_schreiber said:

Hey Marco,

FxCop is consisted of two things: The engine which bubbles up your exceptions (when you didn't follow the rules) and the rules themselves. Maybe as a community we can write the rules together and only one will have to write the engine itself?

July 20, 2008 10:31 AM

Marco Russo (SQLBI) said:

Miky, it would be unsane writing another engine, considering that Mosha already written one. The best thing is to find enough people writing (or at least willing to write) rules that we could convince Mosha to implement a pluggable architecture... :)

Ok, We are in two (I don't have so much time, but at least I would try to look at rules definition). Another couple of guys and we could make a temptative...


July 20, 2008 10:56 AM

Leave a Comment


About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement