Browse by Tags

• mdx
• performance

• Screencast of “MDX Studio to the rescue” presentation

  During MS BI Conference 2008 I had a presentation called “Got MDX problems ? MDX Studio to the rescue !”. Given how the theme of self-service BI has been in the center of the conference, I decided to apply some self-service BI to analyze the performance Read More... Posted Saturday, October 11, 2008 2:50 PM by mosha | 5 Comments Filed under: mdx studio

• Hierarchical trace profiling with MDX Studio

  Profiling and tracing functionality of Analysis Services is very valuable in analyzing query performance. Trace contains wealth of information about what is happening in the server. However, I found out, that this information might not be very easy to Read More... Posted Sunday, September 21, 2008 6:30 PM by mosha | 1 Comments Filed under: mdx studio

• Inspecting calculation dependencies with MDX Studio

  MDX Studio is a universal tool for developing, debugging and analyzing MDX. With 0.4.6 release , there is a new feature in MDX Studio which allows to inspect and analyze dependencies between different calculations. Dependencies are automatically calculated Read More... Posted Sunday, September 07, 2008 5:52 PM by mosha | (Comments Off) Filed under: mdx studio

• Intellisense in MDX Studio

  With Visual Studio and other modern IDEs, Intellisense became a must have tool in the developer’s toolset, boosting productivity. MDX developers have asked for it, but full, context-dependant intellisense wasn’t available. Until now. MDX Studio now features Read More... Posted Friday, August 22, 2008 1:50 AM by mosha | (Comments Off) Filed under: mdx studio

• Product Volatility: Optimizing MDX with MDX Studio

  In this article we will show how to take typical, everyday MDX and optimize it by simply following advices of MDX Studio Analyzer. As a starting point, I will take “ Product Volatility ” example as published by Thomas Ivarson in his blog. It is a perfect Read More... Posted Tuesday, July 29, 2008 9:38 PM by mosha | (Comments Off) Filed under: mdx, mdx studio, performance

• MDX Formatting with MDX Studio

  Darren Gosbell put up a blog post about MDX Formatting, where he describes how he prefers to format MDX to look nice on the screen. So I thought – why to leave to a human something that machine can do. I decided to implement these rules (with some modifications) Read More... Posted Monday, June 16, 2008 5:20 PM by mosha | 2 Comments Filed under: mdx studio