Again another great blog at Teo Lachev’s Weblog, this time he creates some relative dates implementation in an Analysis Services cube, like the default time dimensions in the Cognos Powercubes. He also found a great “Translating Cognos PowerPlay Transformer Relative Date Functionality into SQL Server Analysis Services (SSAS)” whitepaper by David Greenberg. It’s a different aproach than my own using time sets to filter the data. Theo uses a Dimension where he fill the values with MDX query’s, when I have the time i’ll try this one my self, it looks great.
Read his approach at: http://prologika.com