Home > MDX Challenges > MDX #29–Co-authored MDX with SSAS 2012 Cookbook

MDX #29–Co-authored MDX with SSAS 2012 Cookbook

I have been absent from this blog for the last few months. For those who have noticed, I’d like to offer my apology and also provide an excuse. I hope that co-authoring a book is a good enough excuse.

For the last few months, I have been working on the MDX with SSAS 2012 Cookbook (many late-night writing). I am very pleased to announced that the MDX with SSAS 2012 Cookbook is now published.

It is available on both Amazon and http://www.packtpub.com. From the publisher’s site, you can download the sample chapter, and all the MDX script files.

I feel quite relieved that I have reached this milestone. I am eager to come back to do more blogging on MDX and T-SQL, and SSIS/SSAS/SSRS.

(I am not sure why there is only the Kindle Edition available on Amazon. I’ll be get more info from the publisher.)

  1. Ying Z
    September 30, 2013 at 7:48 am

    Congs! I just land one last week, and really enjoy it. Thank you so much for effort on MDX.

    I just have a urgent request, could you please give me a hint what is going on with my code below. My requirement is to return the first month sales count for the first month based on the hire date. Thank you in advance.

    WITH MEMBER MEASURES.FIRSTMONTH AS {[Employee].[Hire Date].CURRENTMEMBER.LAG(1),[Measures].[Reseller Order Count]}

    SELECT {[Measures].[Reseller Order Count],MEASURES.FIRSTMONTH} ON 0, NON EMPTY [Employee].[Employee Department].[Employee].MEMBERS *[Employee].[Hire Date].[Hire Date] ON 1 FROM [Channel Sales]




  2. October 1, 2013 at 3:30 pm

    Hi Ying,

    In Chapter 4 “Concise Reporting” of my book “MDX with SSAS 2012 Cookbook”, look at the third recipe “Identifying the best/worst members for each member of another hierarchy” to see how the set “Top 5 Resellers per Country” is defined using the Generate() function.

    Good luck,



  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: