MDX Training Part 1

The full form of MDX is Multi Dimensional eXpression. This is used to query OLAP cube. It means you can select or retrieve the data from OLAP cube using MDX . In this course i have used SQL Server Analysis Services technology to fetch the data using MDX queries.

To make it more clear i can say , we write SQL commands to select the data from the database . In the same way we write MDX queries to select the data from OLAP cube.

In this online MDX Training video Course, following are the course contents which are covered

Structure of the cube

How MDX Queries Fetch the data from the cube

How to create a basic cube

What is the purpose of Hierarchy

How to create hierarchies

How to modify the existing cube

Terminologies – Children,Member and Level

Set – { }

Tuple – ( )

Default measure

Filter condition

Having condition

Where condition

Difference between where and having condition in MDX

Calculated Member

Named set

Query scoped and Session scoped Calculated Member

Query scoped and Session scoped Namedset

In this MDX video tutorial ,quiz, lab exercises and demonstration exercises are also included. With all these practice activities participant will feel more confident and will be able to write basic MDX scripts by himself or herself. If participant is working in a company where MDX scripts are prewritten then participants will be able to understand those scripts after learning this course.