Writing MDX queries using Analysis Services 2008 R2

מק"ט: #70004 | משך קורס: 24 שעות אק'

This 3-day hands-on, instructor led course will guide you step-by-step through the Analysis Service 2008 R2 Multi Dimensional eXpression (MDX) query language.
This course provides students with the knowledge and skills necessary to use MDX queries and expressions to solve read-world problems.

הקורס פעיל לקבוצות מטעם ארגונים בלבד, ניתן לשלוח פנייה רק אם מדובר בקבוצה
*שדות חובה
PDF version


  • Understand and use multidimensional terminology.
  • Add calculated members to a cube.
  • Use MDX member functions to navigate within a hierarchy and manipulate sets.
  • Calculate formulas for specific blocks of cells.
  • Analyze MDX query performance
  • Monitor SSAS 2008 R2 performance


    קהל יעד

    Professional database developers or Analysis Services developers who have one year or more of on-the-job experience developing Analysis Services database solutions in an enterprise environment.
    DBA of Analysis Services server should also attend the course.

    תנאי קדם

    Before attending this course, students must have basic understanding of OLAP: cubes, dimensions and measures.


    Module 1: MDX Foundations

    • OLAP Databases
    • Warehouses and ETL 
    • The Role of MDX
    • MDX Member Names
    • Tuples, Sets and Calculated Members


    Module 2: Writing Basic MDX Query

    • Understanding MDX Query Statements
    • Creating Simple MDX Query Statements


    Module 3: MDX Functions

    • Basic MDX Functions
    • advanced MDX functions
    • date / time functions


    Module 4: Creating and Manipulating Sets

    • Using Set Creation Functions
    • Using Set Manipulation Functions
    • Static and Dynamic Named Sets
    • Calculating a Trend


    Module 5: Expressions and Calculated Members

    • Using MDX Expressions
    • Displaying Member Information
    • Displaying Family Tree Relatives
    • Working with Member Properties
    • Using Conditional Expressions
    • Working with Calculated Members


    Module 6: Subcubes

    • Using MDX Subcubes


    Module 7: Analysis Services 2008 R2 Architecture

    • How SSAS 2008 R2 utilizes Memory, IO, CPU
    • Server Configuration
    • Aggregations


    Module 8: Monitoring Analysis Services 2008 R2

    • Building Monitoring Solution of SSAS 2008 R2
    • Using PerfMon
    • Using Profiler
    • Using Dynamic Management Views


    Module 9: Writing Efficient MDX Queries

    • How to avoid common MDX query performance problems.
    • MDX Best Practices


    היקף הקורס הינו 24 שעות אקדמאיות