Replicate the prefabricated relative time periods found in Cognos PowerPlay Transformer and other OLAP Design and Reporting tools. In this article, MSAS and Cognos Architect Bill Pearson shows how to provide relative time reporting capabilities, such as year-to-date, from an Analysis Services cube.

This story continues at http://www.databasejournal.com/featu...le.php/3510111