MDX Training Part 2

In MDX training Part2 video training course advanced concepts of MDX queries are discussed

The basic concepts are already discussed in MDX training course Part 1

Multidimensional eXpressions are used to query and get the data from Multi Dimension OLAP cube.

These video tutorials have used SSAS Cubes to write MDX Queries

This advance online MDX training course is a part of SSAS Training (SQL Server Analysis Services) . The SSAS comes under MSBI Training (Microsoft Business Intelligence) This course is very important to get familiar with all concept of MDX and expert knowledge of the same.

Following are the course contents

Playing with Hierarchies

Descendants Function

Ascendants Functions

Parent

Ancestor

Siblings FirstSibling LastSibling

Firstchild Lastchld

item

PrevMember NextMember

Lag Lead

Hierarchize Function

CurrentMember

Ordinal

More on Order Function

Rank Function

More functions

iif Function

Switch function

Crossjoin Union Except Intersect

DrilldownMember and DrilldownLevel

DrilldownLevelTop and DrilldownLevelBottom

DrilldownMemberTop

DrilldownMemberBottom

Generate Function

Working with Time

How to add Time Intelligence to a Dimesion

YTD QTD MTD WTD

PeriodsToDate

OpeningPeriod

ClosingPeriod

Parallelperiod

LastPeriods

Business Scenarios

Percent Sales Contribution of every Product to the business

Percent Sales Contribution of every Product to its Subcategory and then Percent Sales Contribution of every Subcategory to its Category