Monday, December 8, 2008

MDX Resources

Today I received an email from someone asking what resource material I recommend for MDX with Essbase. After I wrote up and sent the response, I thought it would be something good to post, so below is the body of the email I sent:

I would recommend the following reference material for working with MDX for Essbase
If you have block storage experience then the following PDF is very helpful. You can find a copy at http://www.oracle.com/technetwork/middleware/bi-foundation/4395-calc-to-mdx-wp-133362.pdf
This content can also be found in the technical reference under the MDX node; there is a section called Aggregate Storage Topics.

Beyond the material provided by Hyperion, there are two books I recommend:
Fast Track to MDX – Whitehorn, Zare, and Pasumansky.
Fast Track is not Essbase specific, it is MS Analysis Services focused, but it provides a good introduction to the basics of MDX that I found very useful. Moshe Pasumansky created the MDX language, so it stands to reason if you are serious about learning MDX you should read at least one book that he has authored or co-authored.

MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase, Second Edition – Spofford, Harinath, Webb, Huang, Civardi
Make sure you get the second edition of this book; the second edition is the one that focuses some chapters on Essbase. Again, the content is more on Analysis Services, but at least there are a couple of chapters dedicated to Essbase.
Beyond those resources, practice and experimentation, and leverage the user forums.

Friday, December 5, 2008

Dec Update

Quick update since I haven't posted in a while. I actually have a topic to post on I just haven't gotten around to putting it up, but should have it up soon. Things have been very busy lately, working in the financial services industry is a challenge these days, actually I suppose working in any industry is a challenge these days. Fortunately I do have some distractions, one of which is my participation on the ODTUG Hyperion SIG Board of Directors. Currently the BOD is engaged in putting together the agenda for the Kaleidoscope user conference in Monterey, CA. June 2009. Over the past few weeks, we have been reviewing abstracts and structuring the different tracks for the five days of the conference. I am very pleased with the content we have and really like the way the program is coming together. I strongly urge you to check out http://www.odtugkaleidoscope.com/ and consider attending this year. While expenses are going to be very tight this year for most of us, I strongly suggest you try to attend this conference. Remember one of the main differentiators with this conference is the amount of training you will get. This conference will not be a typical wine and dine vendor junket. The bulk of the conference is devoted to technical training and you will get a lot of it, dollar for dollar there is no better deal on the amount of content you will learn for the price. So I hope to see many of you there and if you do attend, be sure to look for my presentations, I'd love to see you there.

Best Regards