Thursday, March 4, 2010

Debugging MDX with MDX Studio

MDX Studio by Mosha Pasumansky is a gift to the SSAS developers.
MDX Studio is a tool which helps users of Microsoft Analysis Services to analyze complex MDX expressions, monitor performance characteristics of MDX queries and get insight into how MDX interacts with other UDM features such as attribute relationships. MDX Studio provides unique visualization representation of MDX expression and allows the user to interact with different stages of MDX execution.

Interesting feature is Debugging, Video is available on You tube (

In addition to this, many times it requires a tool to format lengthy MDX for better understanding. Fthis purpose, In addition to Desktop version of MDX studio, online MDX studio is also available with some basic functionality. This is available at . I use this a lot when I get to analyze the MDX.

Host Analytics Occupied the Microsoft's spot in Forrester Wave report 2009

This is an interesting news on Microsoft PPS.

As we all know, Microsoft entered into Business Performance Solutions or Corporate Performance solutions or Enter prise solutions space by introducing PPS (Performance Point Server) a few years ago. In the last Forrester Wave report (2007 ) report, Microsoft was also considered as a leader in this space.

But in the latest report published, Microsoft is not listed in the report and Host Analytics (only SaaS CPM Vendor ( took Microsoft's spot on this report.

FYI - Forrester Wave report is produced once in 2 years and it profiles major software product vendors world wide in each solution vertical.