Yet Another Relative Dates Implementation

Yet another relative dates implementation in an Analysis Services cube. So far, I've implemented two. But I'm now starting a project to implement an accounting (G/L) cube and the traditional relative date approach where each relative date is calculated for the current member in the Date dimension doesn't fly anymore. Heck, the business analyst even found the excellent "Translating Cognos PowerPlay Transformer Relative Date Functionality into SQL Server Analysis Services (SSAS)" whitepaper by David Greenberg and told me that's exactly what they need. That's what happens when you have smart users. Gemini anyone? While the business users are not empowered yet, let me share how I implemented this approach.