Print Page - Performance difference between in operator and between

Title: Performance difference between in operator and between
Post by: inu on 13 Feb 2018 12:27:20 AM

Hi Team

I am wroking on performance tuning, where in date prompt(MMM-YY) with multi select is being used , which is degrading performance.
Can i use between operator in place of 'in' operator.

Please suggest

Tegards,
Inam

Title: Re: Performance difference between in operator and between
Post by: Pratap Reddy on 14 Feb 2018 06:33:38 AM

Hi,

You can use 'IN' Operator or if your looking for between concept then you can use 'In Range' while creating the Date Prompt or if ur created Date Prompt then change the properties of Date Prompt Range Property to Yes.

Thanks
Pratap

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: inu on 13 Feb 2018 12:27:20 AM