Why does the value for CUSTOMER_ANNUAL_REPORTING is changed to mixed case?

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.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/26663/why-does-the-value-for-customer-annual-reporting-is-changed-to-mixed-case

Hi @Ivony Ann Paula Salango,

Can you please change your prompt 'Subject COMED' to text instead of drop down values and then type 'Customer' to the prompt as a value and execute the report to see if now it is bringing all expected rows?

Thank you.

Ivony Ann Paula Salango

Hello @Bhaskar Konar ,

Yes, I tried it, but it only returns values with same case. Records should be extracted if it matches with 1 subject COMED.

Ivony Ann Paula Salango

Hi @Bhaskar Konar I created a presentation variable to match the formats. Thank you so much for the idea and solution. Appreciate your help.