Oracle Transactional Business Intelligence

Products Banner

How to add sql query to OTBI filter

Received Response
156
Views
1
Comments

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

from dual)

Tagged:

Answers