LIKE operator in Dashboard Prompt — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

LIKE operator in Dashboard Prompt

Received Response
242
Views
2
Comments
2885278
2885278 Rank 1 - Community Starter
edited Aug 13, 2024 6:03PM in Oracle Analytics Cloud and Server

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:

1.png

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:

2.png

but when I tried to run dashboard the result like this:

3.png

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.

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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
    Souro Rank 2 - Community Beginner

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