Home > MDX Challenges > MDX #4 – Format MDX Queries for Easier Reading

MDX #4 – Format MDX Queries for Easier Reading

MDX queries can be very wordy. Many functions have more than one parameters. All of these make formatting MDX queries for easier reading extremely important.

I recently shared a free tool with a co-worker. I know several free tools. Here are two that I used very often.

    I am not sure who created the first tool. The second tool is created by Mosha Pasumansky. It also has a desktop version. For me the online tool works perfectly.
    Thanks to all the authors.
    I personally like the MDX Studio Online better, because it produces the one-line-per-element style with comma at the beginning of the line. This is the style I’ve been using in all my TSQL codes.
    Here is an sample result from the MDX Studio Online:

   image

 

It also gives you a Parse and Analyze option.

image

Experiment with the formatting MDX queries for easier reading. You will eventually develop your own formatting style.

Categories: MDX Challenges
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: