Oracle Transactional Business Intelligence

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

Schedule an OTBI agent to send the analysis using parameters

Received Response
1360
Views
11
Comments
2»

Answers

  • Sridhar_Rejeti_1423
    Sridhar_Rejeti_1423 Rank 2 - Community Beginner

    Hi All,

    I have a similar requirement. I need two schedules on an OTBI report.

    Schedule 1: To run on Wed, Thur and Fri with the prompt, Receipt date = sysdate-2

    Schedule 2: To run on Mon and Tue with the prompt, Receipt date as Sysdate-4

    I have marked Receipt Date parameter/ filter operator as "Is prompted" in the analysis. Created an agent and under "Delivery Content", selected the "Analysis" as content and parameters appeared under "Customize Delivery Content" window.

    How do I pass Sysdate-2 for schedule1 and Sysdate-4 for schedule2? Please advise.

    image.png

    Thanks,
    Sridhar Rejeti