Halo all of master of OBIEE,
First of all, I'd like to thanks for everyone seeing, reading dan trying to give any feedback on this thread.
I have a requirement to show data using LIKE operator in dashboard prompt
I have tried many time to provide this request but did'nt work out.
This is what I had done:
1. First, I've created dashboard prompt like this:
I chose operator 'is equal to /is in' because user wants it as multiselect value
2. on my Analysis, I've made Filter like this:
but when I tried to run dashboard the result like this:
it seemed the sql query that generated was wrong by OBIEE. any of You, Master of OBIEE have suggestion or clue to solve this problem.
How can User have multivalue but with LIKE operator.
Thanks a million.