How to learn MDX

ssas olap mdx
Craig picture Craig · Aug 24, 2008 · Viewed 24.2k times · Source

I am currently learning OLAP & MDX after many years of relational database development.

Any tips on getting started in MDX? What are the best books and resources to learn MDX?

Answer

Kevin Dente picture Kevin Dente · Aug 25, 2008

A classic, albeit a bit dated, book is Fast Track to MDX. It's a great overview and a quick read, though it doesn't cover the new MDX features of SQL Server 2005.

The Spofford book MDX Solutions is more up date and a little deeper, but a bit harder to get through.

I also highly recommend the blogs of Mosha Pasumansky, Chris Webb, and Darren Gosbell.

Related questions

SSAS MDX WHERE clause syntax - filtering multiple values from the same hierarchy

I'm quite new to data warehousing and MDX queries, and I realize that I'm probably not using the MDX syntax properly in the case below. I'm using SSAS 2005 on MS SQL Server 2005 and would like to query my cube and …

Read More
How do I define a Calculated Measure in MDX based on a Dimension Attribute?

I would like to create a calculated measure that sums up only a specific subset of records in my fact table based on a dimension attribute. Given: Dimension Date LedgerLineItem {Charge, Payment, Write-Off, Copay, Credit} Measures LedgerAmount Relationships * LedgerLineItem is …

Read More
How to sum a calculated measure?

I have a fairly complex calculated measure that works perfectly for each row of data from a cube. However, I then need a sum of those values line by line. But the behavior of calculated measures seems to be in …

Read More