Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
BIP Report Dynamically
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.
Answers
-
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() MethodRegards,
Kentaro0 -
Use {(SYSDATE()$} see:
Rgds,
Kevin
0 -
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.).
0 -
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.
0
