The Next step on using SQL Server Analysis Service (SSAS) as Business Intelligence (BI) / Warehouse (BW) platform is to master Multi Dimensional Expression (MDX), it’s like Query on T-SQL.
Question, how to master MDX script language on SSAS (SQL Server Analysis Service) ? or where to start ?
Firts thing first, you have to understand MDX Syntax Conventions (MDX), MDX Statement Reference (MDX) , MDX Operator Reference (MDX) and especially theese MDX Function Reference
- Array Functions
- Hierarchy Functions
- Level Functions
- Logical Functions
- Member Functions
- Numeric Functions
- Set Functions
- String Functions
- Subcube Functions
- Tuple Functions
source : msdn