Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Using REPLACE on multi-value presentation variable, then pass on to filter IN
Is it possible to use string functions, like REPLACE, on presentation variables holding multiple values and then passing them on to a filter?
For example if a user uses a barcode scanner to enter product IDs into the dashboard prompt, can I use replace to add a comma between the IDs and then pass this onto the filter?
The prompt works fine if the user enters multi-values already separated with semicolons, but this isn't as quick/easy.
Answers
-
You could put logic into a filter. Create a filter and then tick convert to SQL
0 -
I trued this but it didn't work: "Product ID" IN (REPLACE(@{pid},'V',',V')
Each product ID starts with a V, so this would be an easy way to add a comma before. Of course, then I'll have to figure out how to ignore the first V in the string, but one step at a time.
0 -
Can see a missing bracket there but assume it was just lost in copy/paste. What was the error?
0 -
You might need to put quotes around your values too. I have done something like this in the past but can't remember what/how so just throwing out ideas that may or may not work!
0