Wednesday, August 11, 2010

MDX Tips from BI Conference


By Dan Meyers

Below is a link to a video and the accompanying slide deck for an MDX session that I sat in on at the Microsoft BI Conference in New Orleans. 

 http://www.msteched.com/2010/NorthAmerica/BIE11-INT

He presents a different way to do your time period calculations using a Utility dimension in SSAS.  I think it’s interesting how he has created a hierarchy within the dimension. 

BLOG - MDX Tips

Other MDX samples include moving dates and how to handle time zone differences.

There are some zip files embedded in some of the slides that will give you an XMLA script to create the sample on your laptop or the demo server.

Cheers,

Dan Meyers
Senior Business Intelligence Consultant

No comments:

Post a Comment