Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: srinu_anu2007 on 13 Feb 2014 03:13:24 AM

Title: Last 7 months data
Post by: srinu_anu2007 on 13 Feb 2014 03:13:24 AM
Hi,

I have Year and Month prompts , both are coming from different dim's and i want to show when u select the Year:2014 and Month:Feb
it should display from 201402 to last 7months.i.e201401,201401,201312,201311...etc how do we relate for month and year?

Iam not sure about to convert from Char to numeric(Month prompt)?

Can anyone done before please help on this? and Iam using DMR package.

Thanks,
Text only | Text with Images