LIKE operator in Dashboard Prompt

2885278

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.

Thomas Dodds

SQL generated is not wrong ... you are going to have a difficult time getting OBIEE to write the equivalent of on its own ...

REGEXP_LIKE (column, 'ABC.*|XYZ.*|PQR.*')

Given what you've posted you'd be better off setting a logical grouping (hierarchy) for your status codes to achieve the same result.   I don't see a repetition past the second character - do all the 'NO%' go together?

Souro

As suggested by Thomas , maybe u can use the evaluate function to write a REGEXP , by converting the filter to SQL option.