SQL Server Analysis Services MDX Script Debugger
The MDX Script Debugger allows you to debug the performance of the MDX Script of your SQL Server Analysis Services cube.
It takes any reference query and executes it against the target cube. It starts with a blank MDX script and basically adds a new command before each subsequent execution of the query. The output is the complete list of the single MDX script commands, their impact on the execution of the reference query and which commands had effectively been used for the query

Supported Features:

  • Check which SCOPES are effectively used by a given query
  • Also works with leaf-level assignments to physical measures which are aggregated upwards
  • Check performance of each assignment for a given query
  • Check runtime vs. reference query and vs. previous statement
  • Export results to XML
  • Test custom MDX-Script without changing the cube
  • Automatically move CREATE MEMBER statements on top of the MDX script
    (useful if they are used in the reference query)
  • Clear Cache support before execution
  • Interactive Layout / Asynchronous execution

 

(Results View)

 

(Custom MDX Script)

 

The download can be found here:
https://mdxscriptdebugger.codeplex.com/releases

Last edited Feb 17, 2015 at 8:47 PM by gbrueckl, version 10