Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Force prompt input to Uppercase in OBIEE 12c
Hi All,
Is there a way in obiee on how to force prompt input values to be always in Uppercase and do a equals to search when it gets passed to report.
Thanks,
Swathi
Answers
-
If this is free text then no, not without using java script.
Though you could make the prompt populate a variable and then do upper(@{YourVariableNameHere}{DEFAULT_VALUE_HERE) = Your.Columnhere in the analysis that is 'catching' the prompt.
If it is driven by a value list then you could convert the value list to SQL and then put the upper around the column name.
0 -
+1 to Robert
But I definitely would NOT go for JS hacking even if you find a snippet online but rather capture the value entered in the free text prompt and then apply it in upper case - just make sure you display the filter visually so people know what gets applied.
0 -
Amen!
0