Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Why does the value for CUSTOMER_ANNUAL_REPORTING is changed to mixed case?
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
Best Answer
-
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:
Hope this help.
Thank you.
0
Answers
-
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.
0 -
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.
0 -
Hi @Bhaskar Konar I created a presentation variable to match the formats. Thank you so much for the idea and solution. Appreciate your help.
0