Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to add sql query to OTBI filter

Received Response
551
Views
1
Comments
User_30IGU
User_30IGU Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Forum

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)

Tagged:

Answers

  • Praveen Kumar Akkala-Oracle
    Praveen Kumar Akkala-Oracle Rank 6 - Analytics & AI Lead

    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