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.
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!
worked like a charm. thank you very much.
Very helpful suggestions.
Thank you very much @Josue Jimenez!
