Advanced MDX - Performance, Optimization, and the MDX Script

This is an advanced MDX course. Half of the first day is devoted to advanced MDX functions and sets. The second half of the day is focussed on effectively using the MDX Script. The second day is devoted completely to examining strategies for monitoring and optimizing MDX. Analysis Services in SQL Server 2012 is used in the course, but almost all of the content is also applicable to Analysis Services in SQL Server 2008.
Before attending this course, it is recommended that students have the following skills:Ability to create and understand MDX calculationsThorough understanding of sets and tuplesAbility to use all the basic MDX functionsIt is recommended that the students have taken the SolidQ course MDX for Business LogicNOTE: This is an Advanced MDX course. If a student is unfamiliar with MDX before they take this course, they are unlikely to receive much benefit from it.
2 Days/Lecture & Lab
This course is intended for individuals that are developing or supporting Analysis Services multidimensional cubes.
  • Advanced Functions
  • Advanced Set Topics
  • The MDX Scripting
  • Building a Time Calculation Hierarchy
  • MDX Performance Analysis
  • Enabling Block Computation
  • Other Calculation Performance Strategies
  • Using Subselects and Subcubes

Related Scheduled Courses