Oracle Analytics and AI

Ivony Ann Paula Salango

Hello,

I am updating activity report. The field Subject COMED have multiple values, and I used REPLACE to use the Subject COMED as filter. (REPLACE "Activity Extension"."Extension Attribute LOV 015", 'CUSTOMER_ANNUAL_REPORTING', 'Customer Annual Reporting')

Column Values

Prompt Values

Now, when I use the Customer Annual Reporting, it is only filtering records with exact match even if the operator is 'contains any'.

What I need is to filter all activities having Customer Annual Reporting, but the results are not returning the values because the case are mixed for customer annual reporting

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/69784#Comment_69784

Hi @Ivony Ann Paula Salango,

Yes agree with you it is case sensitive.

As a work around you can define the presentation variable and use either lower or upper function on that field and you have to use that particular case while executing the prompt and it should bring all data.

Please find attached a prompt and report and just set this in your my dashboard and try executing by providing some string in lower case (I've used the lower function). It is working for me. you can implement the same concept as a work around.

Report Definition:

Prompt Definition:

Report & Prompt catalog:

Names_pmt_contains_testing.catalog

contains_pmt.catalog

Hope this help.

Thank you.