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.
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
Use {(SYSDATE()$} see:
https://docs.oracle.com/middleware/12212/bip/BIPUG/GUID-BC0A8B60-1BB5-4D85-85BB-B199C1A5C418.htm#BIPUG219
Rgds,
Kevin
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.).
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.
I created a XLSX template in Oracle Analytics Publisher Desktop 26.01.01 and uploaded the template to a BI Publisher report in OTBI. Things worked initially, but this morning when running the report I received an error: The report cannot be rendered because of an error, please contact the administrator. Error Detail:…
Hi All, I have a question regarding the BI Publisher Outputs. I have configured the rtf template output as Excel but when the XML Report Publisher program completes and I click on View Output, the output opens in a browser and renders as an HTML. Can some one please assist why this is so. The BI Publisher version is…
The issue is related to the NordPass browser extension installed via our corporate policy. Issue observed: Users were unable to upload custom BI Publisher templates in Oracle Fusion (BI Publisher / Oracle Analytics) using Microsoft Edge and Google Chrome. The upload dialog remained indefinitely at "Uploading, please…
Hi, We are scheduling a report to be sent out every week. We were wondering if it was possible to keep the latest date that the report ran as a parameter somewhere so that we could use that to only fetch the values in the report which have a latest update time of after the last run of the report? This way we'd only be…
