Categories
OBIEE Filter with "contains all / like" and multiple values in presentation variable
Hello,
I´m looking for a solution to create a filter with "contains all" from a presentation variable. But I need not a compare with a list, I need the like-operator.
Example:
column "foo" to filter: "A,B,C,D" (all values in one column as string)
selected values from dashboard prompt: "B" and "C"
When I use this in filter:
"foo" LIKE @{prompted}['%@%']{'%B%'}
Answers run fine, as long as only one filtervalue is selected. With multiple values answers construct the following wrong sql:
... AND ("foo" LIKE '%B%','%C%') => wrong
instead of
... AND "foo" LIKE '%B%' OR "foo" LIKE '%C%' => OK
another test:
"foo" @{prompted}[LIKE '%@%']{LIKE '%B%'} => ... AND ("foo" LIKE '%B%',LIKE '%C%') => wrong
How can I get the correct filterstatement with answers and a presentation variable?
Have anyone a idea for a solution?
Thank You!