nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Data Model with single parameter not returning sql query results

Builder

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.

02 Data Model SQL Query with Parameter.jpg

Find more posts tagged with

Accepted answers

Josue Jimenez

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!

All comments

Josue Jimenez

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!

Builder

worked like a charm. thank you very much.

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/63391#Comment_63391

Very helpful suggestions.

Thank you very much @Josue Jimenez!

Upcoming Event

AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…

Top Leaders