<p>I am currently learning OLAP &amp; MDX after many years of relational database development.  </p>

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

[{'answer_id': 25663, 'author': 'Kevin Dente', 'author_id': 9, 'author_profile': 'https://Stackoverflow.com/users/9', 'pm_score': 5, 'selected': True, 'text': '<p>A classic, albeit a bit dated, book is <a href="https://rads.stackoverflow.com/amzn/click/com/1846281741" rel="nofollow noreferrer" rel="nofollow noreferrer">Fast Track to MDX</a>. It\'s a great overview and a quick read, though it doesn\'t cover the new MDX features of SQL Server 2005.</p>\n<p>The Spofford book <a href="https://rads.stackoverflow.com/amzn/click/com/0471748080" rel="nofollow noreferrer" rel="nofollow noreferrer">MDX Solutions</a> is more up date and a little deeper, but a bit harder to get through.</p>\n<p>I also highly recommend the blogs of <a href="https://web.archive.org/web/20180325203953/http://sqlblog.com:80/blogs/mosha/default.aspx" rel="nofollow noreferrer">Mosha Pasumansky</a>, <a href="https://blog.crossjoin.co.uk/" rel="nofollow noreferrer">Chris Webb</a>, and <a href="https://web.archive.org/web/20210211164051/http://www.geekswithblogs.net/darrengosbell/Default.aspx" rel="nofollow noreferrer">Darren Gosbell</a>.</p>\n'}, {'answer_id': 70429, 'author': 'Magnus Smith', 'author_id': 11461, 'author_profile': 'https://Stackoverflow.com/users/11461', 'pm_score': 3, 'selected': False, 'text': "<p>I found the Spoffard book not very helpful. MDX is such an oddity compared to other languages you'll learn, it's so hard to grasp from a dry book. I really would recommend a training course, otherwise you will flounder for ages. A course will really jump-start you, and it provides access to an expert when you have questions which don't seem to have online answers.</p>\n\n<p>The worst trap to fall into, is to continually compare it with SQL! It uses some of the same keywords, but they mean something totally different, which makes the mental jump annoyingly harder.</p>\n\n<p>I think the most efficient way to learn either OLAP or MDX would be to find someone who knows it, and get them to show you around, begin with some small changes, or some very simple queries. </p>\n"}, {'answer_id': 700544, 'author': 'adolf garlic ', 'author_id': 79076, 'author_profile': 'https://Stackoverflow.com/users/79076', 'pm_score': 2, 'selected': False, 'text': '<p>If you create a Pivot Table that uses a cube (in Excel), you can see the query that is being sent using this (towards the bottom of the page)</p>\n\n<p><a href="http://www.codeplex.com/OlapPivotTableExtend" rel="nofollow noreferrer">http://www.codeplex.com/OlapPivotTableExtend</a></p>\n\n<p>That might be a good way of getting a feel for the simpler stuff.</p>\n\n<p>N.B. This is only in Excel2007, not sure about earlier versions</p>\n'}, {'answer_id': 2082819, 'author': 'Nathan Griffiths', 'author_id': 46239, 'author_profile': 'https://Stackoverflow.com/users/46239', 'pm_score': 2, 'selected': False, 'text': '<p>You should also try and get hold of <a href="http://www.mdxstudio.com/" rel="nofollow noreferrer">MDX Studio</a>, a free MDX query tool written by Mosha Pasumansky (one of the original creators of MDX). It has similar MDX functionality to SQL Management Studio, but also allows you to parse and format queries, which can be very handy when trying to decipher them.</p>\n'}, {'answer_id': 7928077, 'author': 'Rob Willis', 'author_id': 333315, 'author_profile': 'https://Stackoverflow.com/users/333315', 'pm_score': 1, 'selected': False, 'text': '<p>We used the LearnItFirst.com training videos and found them to be a very thorough introduction to SSAS and MDX. There are around 40 hours of content plus exercises including around 6 hours of pure MDX Training.</p>\n\n<p>The details for the SSAS Course can be found at: \n<a href="http://www.learnitfirst.com/Course/165/SSAS-2008.aspx" rel="nofollow">Learn IT First SSAS Training</a></p>\n'}, {'answer_id': 8525981, 'author': 'Peter', 'author_id': 1100685, 'author_profile': 'https://Stackoverflow.com/users/1100685', 'pm_score': 2, 'selected': False, 'text': '<p>I would recommend </p>\n\n<p><a href="https://rads.stackoverflow.com/amzn/click/com/1849681309" rel="nofollow noreferrer" rel="nofollow noreferrer">MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook</a></p>\n'}, {'answer_id': 9402201, 'author': 'Paul', 'author_id': 1226770, 'author_profile': 'https://Stackoverflow.com/users/1226770', 'pm_score': 2, 'selected': False, 'text': '<p>Book: MDX Step by Step</p>\n\n<p>Video tutorials, e.g. <a href="http://www.youtube.com/watch?v=12WMPhSm5rU" rel="nofollow" title="MDX tutorial">MDX tutorial</a> and <a href="http://www.youtube.com/watch?v=ctUiHZHr-5M&amp;feature=related" rel="nofollow" title="Analysis Services tutorial">Analysis Services introduction</a> <br/></p>\n\n<p>There are more.</p>\n'}, {'answer_id': 10476399, 'author': 'Marc Polizzi', 'author_id': 430615, 'author_profile': 'https://Stackoverflow.com/users/430615', 'pm_score': 3, 'selected': False, 'text': '<p>Here is an <a href="http://www.iccube.com/support/documentation/mdx_tutorial/gentle_introduction.html">MDX gentle introduction</a>.</p>\n'}, {'answer_id': 10730572, 'author': 'Jon Crowell', 'author_id': 138938, 'author_profile': 'https://Stackoverflow.com/users/138938', 'pm_score': 1, 'selected': False, 'text': "<p>Besides the books and resources mentioned by others, the easiest way to kick-start your MDX learning is to get a copy of ProClarity. Unfortunately getting your hands on ProClarity is nowhere near as easy as it used to be. Microsoft bought the company in 2006, and it is now licensed through PerformancePoint, I believe. Oh yeah, and they quit development on the product.</p>\n\n<p>Having said all that, if you are able to get a copy, you can build queries by dragging and dropping dimensions and measures onto your rows and columns. The results of the query are then displayed in either a grid, a chart, or both.</p>\n\n<p>How does this help you learn MDX? ProClarity lets you see the MDX for each query. It isn't always the most elegant MDX, but it will help you quickly learn how to write lots of different queries.</p>\n"}, {'answer_id': 13408198, 'author': 'Aaron Kempf', 'author_id': 565882, 'author_profile': 'https://Stackoverflow.com/users/565882', 'pm_score': 2, 'selected': False, 'text': '<p>I prefer dragging and dropping fields around in MS Excel, and then using SQL Server profiler to capture trace against SSAS.  This way, you get an awesome frontend for building queries, and then you can get the queries that Excel is using through the profiler.</p>\n'}]
['https://Stackoverflow.com/questions/24963', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1073/']