Topics covered in this session include:

• What MDX is
• Comparing MDX to T-SQL
• Thinking about Multidimensional Space
• Exploring Options for Using MDX

Topics in this session include:

• Understaning the MDX Query Editor
• Building MDX Queries
• Adding Sets to a Query

Topics in this session include:

• Creating Sets with Functions
• Using Functions for Set Operations
• Working with Hierarchial Sets

Topics covered in this session include:

• Understanding Types of Calculations
• Building Calculated Members
• Exploring More MDX Functions

Topics covered in this session include:

• Creating Calculated Measures and Custom Members
• Defining Named Sets
• Creating KPIs

Topics covered in this session include:

• Introducing the MDX Script
• Adding Calculations to the MDX Script
• Debugging a MDX Script

Topics covered in this session include:

• Configuring User Access
• Defining Dimension Security
• Configuring Cell-level Security
• Implementing Dynamic Security

Topics covered in this session include:

• Using SQL Server Profiler to Analyze Queries
• Optimizing Queries for the Formula Engine
• Optimizing Queries for the Storage Engine