Implementing Relative Time in Cognos BI

August 07, 2014

Cognos 10, Metadata Modeling, OLAP, Report Authoring

Using OLAP Modeling & Reporting Tools

Year-to-date, trailing 12 months, this month, this week, etc., are examples of relative time categories. With Cognos Business Intelligence, relative time definitions can be managed in either the metadata or the reporting layer.

During this webinar, we demonstrate three different techniques for managing relative time: using OLAP modeling with Cognos Transformer, using Cognos Cube Designer, and using the reporting tools. Demonstrations include how to manage the out-of-the-box relative time definitions, as well as how to create your own custom definitions.

Albert Valdez, Senturus’ Vice President of Learning Solutions, showcases the following hands-on techniques during this 90-minute event:

  • Enable and manage standard relative time definitions in both Transformer and Cube Designer.
  • Create custom relative time definitions in both Transformer and Cube Designer.
  • Create dynamic reports by both leveraging pre-defined relative time members as well as creating custom definitions in the report.

BI Developers, BI Report Writers, BI Authors, BI Power Users, BI Report Consumers, Cognos and BI Support Staff


IBM Cognos BI 10, IBM Cognos Transformer, IBM Cognos Cube Designer, IBM Cognos Report Studio


Albert Valdez
Vice President of Learning Solutions, Senturus Inc.

Albert has spent the last 13 years as a technical trainer focused on business intelligence and performance management.  Before joining Senturus, he was a Senior Education Specialist at Cognos for five years.  He is an IBM Cognos Certified Trainer and has his lifetime CTT and certification from CompTIA.  Since 2007, Albert has acted as a Senior Consultant, Solutions Architect, Director of Education and Vice-President of Learning Solutions for Senturus.