The MDX Query Language for OLAP Cubes (with SSAS)


overall satisfaction for this course

?Average calculated from scores obtained from 84 participants who took this course.
  • Duration 2 days
  • Regular fee 945
  • Preferential fee 795?
  • Locations
    • Quebec City
    • Montreal
  • Laboratory

Formation path :

Databases Training Paths

View path


To provide the knowledge and skills required to effectively design MDX queries.

Targeted audience

Developers and BI projects heads.


Familiarity with databases, with data warehouses (Course BD106) and with OLAP databases using MS SQL Server 2005/2008 (Course MS517).

Customer Testimonials

Good teacher, interesting and relevant content.

Martin C. / Analyste Principal, Lantic Inc.


  • Overview of MDX: Cubes, Measures, Dimensions, Hierarchies, Members, Sets
  • Designing MDX queries: the syntax of a SELECT query, the notion of axes, the SELECT/FROM/WHERE clause
  • Calculated members and named sets: overview of named sets and their use in PKI
  • Navigation and selection: selecting members in a hierarchy (PARENT, CHILDREN, DESCENDANTS, etc.)
  • Sorting and grouping data
  • Using scripts to customize a cube: using expressions and parameters
  • Modifying the multidimensional environment: optimization techniques


*Unless stated otherwise, all sessions are in French.
  • Quebec City

    November 14 to November 15 2017

  • Montreal

    March 28 to March 29 2018

Trainer(s) assigned(s)

Other course(s) in this category