Print Page - Show data for rolling 13 months period

Title: Show data for rolling 13 months period
Post by: bepanda on 21 Jan 2014 01:55:43 PM

I'm using Cognos 10 BI.
I have a table
Table1: col1 varchar, col2 timestamp, col3 integer
I would like to show a Crosstab of col1 and col3 over a 13 months period, every time I run my report without having to enter the start date.
Any smart way to do this?

Title: Re: Show data for rolling 13 months period
Post by: MFGF on 22 Jan 2014 02:35:08 AM

Hi,

Add a filter with the expression:

[Col2] between _add_months (current_timestamp, -13) and current_timestamp

Cheers!

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: bepanda on 21 Jan 2014 01:55:43 PM