How to add sql query to OTBI filter

Question

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 · Answer

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