Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
Builder
Rank 1 - Community Starter
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.
0
Best 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!
3
Answers
-
worked like a charm. thank you very much.
1 -
Very helpful suggestions.
Thank you very much @Josue Jimenez!
1
