Program Session:
The Dirty Dozen: 12 Ways to Write Poorly Performing MDX Queries

 

Presenter
Steve Simon (State Street Corporation)

Session Details
OLAP cubes have become an important means of delivering valuable information from complex data within the Corporate Data Warehouse. Adequate information helps the corporate decision makers take the necessary steps to ensure that the enterprise is heading in the correct direction, especially in tough and turbulent economic times.

This is certainly true within the realm of the financial and portfolio management world, which has been under the microscope for the past 18 months.

This beginner to intermediate level hands-on presentation is aimed at showing the attendee some of the pitfalls of poorly designed and performing MDX queries, and how many of the queries may be optimized to ensure that they are both efficient and effective.

Through a series of Before and After scenarios, the attendee will see how we have managed to improve the performance our queries and learn of some of the ‘Gotcha’s' that we encountered along the way.

Optimally efficient and effective MDX queries help our end users obtain the information necessary for corporate decision making. This in turn helps them work smartly and helps the enterprise achieve its corporate goals and mission statement.

Register now for PASS European Conference 2010

Return complete session listings