MDX Training Part 2

About this course

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