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.
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
