Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

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

Data Model with single parameter not returning sql query results

Accepted answer
31
Views
3
Comments
Builder
Builder Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Forum

i am trying to create a very, very simple data model, to turn into a bip report, that contains one parameter. the data model query works independently of the parameter (when the parameter is not defined and is not part of the sql query), but does not work when the parameter is added. thank you.

01 Data Model Properties.jpg 02 Data Model SQL Query with Parameter.jpg 03 Data Model LOV.jpg 04 Data Model Parameter.jpg 05 Data Model Validate.jpg 06 Data Model Data Tab Parameters.jpg 07 Data Model Data Executed.jpg

Best Answer

  • Josue Jimenez
    Josue Jimenez Rank 3 - Community Apprentice
    Answer ✓


    Hello!

    The sentence you wrote for the LIKE action is incorrect. Try the following form. I recommend using UPPER expresion, because words are almost never written correctly.

    WHERE UPPER(COLUMN_NAME) LIKE UPPER('%'||:Parameter||'%')

    Regards!

Answers