If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Performance difference between in operator and between

Started by inu, 13 Feb 2018 12:27:20 AM

Previous topic - Next topic

inu

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

Pratap Reddy

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