IBM Support

Filter dialog no longer offers filtering the report with "starts with", "ends with", "contains" operations

Question & Answer


Question

In Cognos BI version10, when creating a report and selecting 'Filter for Report' on opening the Filter option, there was a drop down menu beside the 'Search' which provided the options to search by "starts with", "ends with", "contains" operation. In Cognos Analytics 11, this functionality is no longer available. Is there a way to reinstate it?

Cause

Different functionality between products

Answer

This functionality has been removed within reports. However an RFE has been logged on which you can vote to have it reinstated:
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=113733

Available documentation on filter...
Cognos Analytics 11:
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_wrkdat_filter_data_rel.html
Cognos BI 10:
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_rptstd_fin.10.2.2.doc/t_bia_filter_items_not_in_report.html
 
The Cognos Analytics documentation clearly does not include the options

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 June 2018

UID

swg22017223