none
looking for MDX exercises RRS feed

  • Question

  • I had a crash course in MDX several months ago that went from very basic MDX to some black belt level stuff. Unfortunately, I haven't used MDX since the course and I forgot most of it. Now, I am trying to get refreshed on MDX and I'm looking for some exercises that gradually build on top of eachother using the AdventureWorks OLAP cube. I surfed thru the forum and I found examples but these are unrelated examples. I'm looking for a series of related exercises. Any links or books anyone can suggest?

    Friday, May 9, 2008 7:33 PM

Answers

  • Good thought! I am going through the "MDX-solutions" book by George Spofford,Chris Webb and rewriting the examples for Adventure Works.

     

    If you search for Deepak Puri here, he is the best in writing MDX examples, both complex and easier, in this newsgroup, on top of the Adventure Works cube project. I collect most of his replies and put them in my MDX script library.

     

    Moshas site is also good but his writing has been slowing down during the last six months.

    http://sqlblog.com/blogs/mosha/default.aspx

     

    Mosha uses the the Adventure Works cube frequently in his writing.

     

    I would like a good MDX book with the approach of solving business problems with MDX but the only book that tried this was written for AS2000(Fast Track to MDX).

     

    BR

    Thomas Ivarsson

    Friday, May 9, 2008 9:11 PM
    Moderator

All replies

  • It depends on what you mean by exercises but the only free and structured site I know about is this:

     

    http://www.databasejournal.com/features/article.php/3593466

     

    Look for William E. Pearson.

     

    This link has an approach of a dictionary of useful MDX syntax but is weak on business problems.

     

    Vidas has a great site here:

     

    http://www.ssas-info.com/

     

    I suspect that you will have to navigate around a lot of MDX-oriented blogs.

     

    HTH

    Thomas Ivarsson

     

     

     

    Friday, May 9, 2008 8:34 PM
    Moderator
  • It would be ideal if someone can suggest a book or a site that uses AdventureWorks cube to give MDX problems with proposed solutions, that builds from basic to sophisticated MDX. But I guess, I just need to look more or just make up my own problems... it's just that it's difficult to think up problems without a real world motivation. Thanks anyway.

     

    Friday, May 9, 2008 8:56 PM
  • Good thought! I am going through the "MDX-solutions" book by George Spofford,Chris Webb and rewriting the examples for Adventure Works.

     

    If you search for Deepak Puri here, he is the best in writing MDX examples, both complex and easier, in this newsgroup, on top of the Adventure Works cube project. I collect most of his replies and put them in my MDX script library.

     

    Moshas site is also good but his writing has been slowing down during the last six months.

    http://sqlblog.com/blogs/mosha/default.aspx

     

    Mosha uses the the Adventure Works cube frequently in his writing.

     

    I would like a good MDX book with the approach of solving business problems with MDX but the only book that tried this was written for AS2000(Fast Track to MDX).

     

    BR

    Thomas Ivarsson

    Friday, May 9, 2008 9:11 PM
    Moderator
  • Thank you for the thoughtful reply.

     

    Monday, May 12, 2008 1:25 PM
  • Thomas,

     

    Can you publish your MDX script library? I think this would be very useful. I am sure Deepak would not mind. Right?

     

    Vidas Matelis

     

    Tuesday, May 13, 2008 12:53 PM
  • Vidas,

     

    No problem but some work needs to be done since my comments is in Swedish. I can send you a raw notepad file and we can discuss of how to present it.

     

     

    Thomas Ivarsson

    Tuesday, May 13, 2008 5:03 PM
    Moderator
  • MDX code snippets are published under MDX cheat sheets on Vidas site here:

     

    http://www.ssas-info.com/ssas-cheat-sheets

     

    Download and have a look.

     

    HTH

    Thomas Ivarsson

    Monday, August 4, 2008 5:55 PM
    Moderator