Translating Cognos PowerPlay Transformer Relative Date Functionality into SQL Server Analysis Services (SSAS)
The SQL Server 2005 business intelligence platform represents a giant leap forward in technology and functionality over products offered by competitors like Cognos and Business Objects. While Microsoft’s overall package is a clear winner, there is still some functionality available in Cognos applications that work better.
As a long time developer of Cognos PowerPlay cube applications, I’ve found the ability to create and use relative dates in reports to be one of the most useful functions available in the Cognos toolset. Almost all companies have the need to look at how some aspects of their business perform over time.
Tags: time dimension, cognos