BIP Report Dynamically

MayurM

Hi

We have a BIP report with daily frequency, and we need to pass the schedule start time to the data model SQL input parameter#p_from_date to fetch the incremental value.

Kurasaki-Oracle

Sorry.
I don't know how to pass when to start to a BIP scheduled job.

Using a SOAP request API in a custom program(such as Python etc) to submit a BIP schedule job could be one of alternate option. You can control when to start the job in your custom program as you like though you need to develop it by yourself.

https://docs.oracle.com/middleware/12213/bip/BIPDV/scheduleservice.htm#CACCCCBD
3.35 scheduleReport() Method

Regards,
Kentaro

Kevin M-Oracle

Use {(SYSDATE()$} see:

https://docs.oracle.com/middleware/12212/bip/BIPUG/GUID-BC0A8B60-1BB5-4D85-85BB-B199C1A5C418.htm#BIPUG219

Rgds,

Kevin

RVohra

If you know the frequency, let's say within last 24 hours, you can use TRUNC(SYSDATE)-1

This automatically picks records from the last 24 hours (yesterday to now).
You can adjust the interval as needed (e.g., use SYSADATE-(1/24) for hourly, etc.).

This avoids parameters altogether if your schedule runs consistently (daily, hourly, etc.).

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/27501/bip-report-dynamically

Hi Mayur,

You can write a with clause CTE in your query which will give you the schedule start date and time and then use that in your main query.

Thanks.