How to add sql query to OTBI filter

User_30IGU · Aug 29, 2023 8:43PM

I want to create an OTBI analysis that gives data between last 7 days. I tried creating a filter using SQL expression but it doesnt work. Can someone pls help with the right syntax to be used?

SQL1:(select sysdate-7 from dual)

SQL2:(select sysdate

OTBI SQL Filter.PNG

from dual)

Praveen Kumar Akkala-Oracle · Sep 14, 2023 9:06PM

Hi @User_30IGU,

Please review the below KM Documents.

Fusion OTBI: How To Use System Date & Auto Passing Of Dates In OTBI Report (Doc ID 2103487.1)

Fusion OTBI: How To Use System Date & Formulas Based On System Date As Part Of Prompts In OTBI Analysis (Doc ID 2106283.1)

Thanks,

Praveen

MFA for Oracle Community

Oracle Transactional Business Intelligence

Categories

How to add sql query to OTBI filter

Answers