Aug 122011
Hi all,
if you’ve been wondering where have I been hiding all these months, the answer is here – I was writing a book for Packt Publishing Ltd. The book, named MDX with Microsoft SQL Server 2008 R2 Analysis Service: Cookbook, is finally out and available on publisher’s site. Soon, it should be available on Amazon and in other popular book stores.
For those of you who prefer the e-book over the paperback edition, it’s good to know that the PDF version already exists on publisher’s site, while the ePub and Mobi are coming soon. Same is with the Kindle Edition on Amazon.
UPDATE (27th of August): On Amazon US, the paperback edition is available here, the Kindle edition here.
Looking forward to receiving your feedback 
I have this book for over a month now (EBook) and I can say that is really great. I also wrote a recommendation about it on my company’s blog: See here (German only): http://flurfunk.sdx-ag.de/2011/08/buchtipp-mdx-cookbook.html
Great work!
Hervorragend sagst du Nicolas?
Thank you!
Congrats Tomislav
Have started going through the book and so far, it’s been fantastic!
Thanks Jason!
Just told the man with the company credit card to place an order for me
Looking forward to reading it!
Congratulations! I’m looking forward reading it!
Very good book. I can not do my project without it.
I am trying to copy the Time Cal example in chapter 6. I have an issue with percentage format of [YTD Year ago %]
It seems format_string(this) = ‘Percent’ in all calculation does not work for me. for example 100% increase, it shows $1.00. it always has $ sign.
I am use sql 2012 release. My script is just very simple as follow
{[Time Calcs].[Calc].&[4]} * { [Measures].[Sales Amount USD], [Measures].[Gross Margin USD] }
what I may have done wrong?
Thank you in advence.
Hua
I did figure out a work around by using format() FUNCTION instead of format_string property , but the value of fore_color propty is not being honored.
Thanks
Hua
Maybe that property is not included in the CELL PROPERTIES part of your MDX query.
Maybe some other calculation overwrites the format for that measure. Try to put that statement in the end of your script.
Hi Tomislav,
I left my review on the book on amazon. Hope more similar book on MDX coming!
Thanks
Hua
Thank you!