Other Versions of this course
DescriptionThis hands-on, instructor led course will guide you step-by-step through the Analysis Service 2008 Multi Dimensional eXpression (MDX) OLAP query language. You will learn a practical approach to solve real-world problems using MDX expressions, calculations and queries, which will allow users to extract valuable information.
Target Audience
This course is intended for: - Developers creating Microsoft Analysis Services solutions
- Database Administrators who are optimizing Microsoft Analysis Services query and browsing speed
- Analysis Services Power Users who want to convert business rules to MDX calculations and queries
- Those who are using MDX with Reporting Services
- Those who are using MDX with PerformancePoint Services for SharePoint Services
Prerequisites
Before attending this course, it is recommended that students have the following skills: - Basic understanding of Analysis Services
- An understanding of multidimensional concepts – cubes, dimensions, attributes, and hierarchies
Course Objectives
Upon completion of this course, the student will be able to:
- Convert business requirements into MDX calculations and queries
- Query data from a cube
- Navigate hierarchies
- Create calculated members
- Create named sets
- Create time-based calculations
- Use all the MDX functions
- Write code to assign values in a specific portion of the cube using the MDX Script
- Debug, analyze, and optimize MDX queries
- Use MDX to create KPIs
- Use MDX in setting Analysis Services security
- Use MDX in Reporting Services
- Use MDX in PerformancePoint Services for SharePoint Services