What are the most relevant similarities between T-SQL and MDX?

I have used T-SQL (CTEs, windowed functions, recursive CTEs, large data, table-valued functions, APPLY, PIVOT, stored procedures, etc.), but have never queried a Microsoft SSAS cube. Are there similar concepts in MDX for the following T-SQL concepts? - PIVOT - UNPIVOT - Windowed functions - Recursive Common Table Expressions Are there any pitfalls for a T-SQL user using MDX? I am hoping there are some common analogies between T-SQL and MDX, that will help someone good at T-SQL transition to MDX. It would also be great if there was a guide for common mistakes that are made when coming from T-SQL into MDX.