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!

Top Leaders

Top Questions

BIP Reports Inventory
Is there a way to extract existing BIP reports saved in a specific folder? Like can capture Report Name, Report Path and Owner for example?
Receiving error when setting up SFTP Delivery Channel
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Session Variables for Use in Activity Center Visualizations
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
Recruiting Real Time and Real Time Events
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
No Option to Export to Excel after 26B
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…