Print Page - Previous 11months data using DMR

Title: Previous 11months data using DMR
Post by: srinu_anu2007 on 09 Jan 2014 04:30:06 AM

Hi,

I have a requirement in crosstab i.e jan,feb,mar....dec[this is for 2014 year] if i select jan i want to display 2013 dec,2013 nov.....upto 11months dat should display and the same as quarters also. Can anybody face this issue please let me know your answers.

Thanks,

Title: Re: Previous 11months data using DMR
Post by: hittony on 09 Jan 2014 04:43:58 AM

Just a filter should work it out :

where [MONTH] between _add_months ( ?PARAMETER_MONTH? , -11 ) and ?PARAMETER_MONTH?

Title: Re: Previous 11months data using DMR
Post by: Satheesh on 10 Jan 2014 07:37:57 AM

Hi,

lastPeriods ( integer_expression , member )

lastPeriods (12;[Month] -> ?Mnth_Param? )

the above [Month] is member.

Use the above function in Slicer

Regards
Sateesh

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: srinu_anu2007 on 09 Jan 2014 04:30:06 AM