Executing a report job based on new record in DB table — Oracle Analytics

Oracle Analytics Cloud and Server

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

Executing a report job based on new record in DB table

Received Response
51
Views
2
Comments

Summary

Executing a report job based on new record in DB table

Content

Executing a report job based on new record in DB table

We have generate and send a report to email based on a new record insertion in a table. We will need to use the values inserted in the table as parameters in the report as well. Any pointers will be highly appreciated. Thanks

Answers

  • timdexter
    timdexter Rank 6 - Analytics Lead

    Just adding to 2807661's answer.

    Its not a push to run the report as soon as there is a new record in the table. Its a case of setting up a BIP report with the trigger to look for a new record and putting that on a very regular schedule. IF you are expecting new records every hour then set the schedule for 30|15|10 mins so that the most a record has to wait to be published is 30|15|10 mins. You can write a query to retrieve the data from the new record to pass the values to a second query as paramters.

    If you want a true push then you are going to have to create a plsql web services sub program to call BIP via its web services. Its some work to set up but could then be leverage through the DB to run reports from PLSQL and SQL.

    Tim

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    You can achieve requirement with schedule Trigger concept https://docs.oracle.com/cd/E23943_01/bi.1111/e22258/add_event_trig.htm#BIPDM389 (creating scheduled trigger). This trigger is associated with sql query , if it returns rows then job will be executed else terminate , you can define sql query if new row is inserted then return data to execute report job. Thanks