Supercharge MDX performance using MDX Studio

MDX Studio can be used 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 of MDX expressions and allows the user to interact with different stages of MDX execution. We all also be looking at behaviour or formula engine and storage engine in context of various queries and how MDX studio helps to peep under the hood and understand what is going wrong with the query.It is built by Mosha Pasumansky, who is inventor of MDX and one of the Architects of Microsoft Analysis Services.

Speaker

I am SQL Server MVP and SQL Server Business Intelligence and C# consultant at CodePerfect Limited . I am also a regular speaker in SQL Server and BI conferences in UK. I have worked with SQL Server BI stack since 2003 and I am Microsoft Certified IT Professional. My main field of expertise are SQL Server Analysis Services, MDX, SQL Server Database Engine, T-SQL, and SSIS and C #.

Ashwani Roy's Sessions

Supercharge MDX performance using MDX Studio

Analysis Services Best Practices

Understanding Graphical Execution Plans

Lets go more functional - F# WHAT , WHY and BI