Need SQL Logic to get data from last bip report scheduled date

Ranjith1166

We have requirement to get report output from sysdate to last report scheduled date.

for example, if report is first scheduled on Jan 1st 2025 and later schedule date is Jan 15th 2025. I need data from 1 Jan 2025 to 15 Jan 2025.

So, is there any SQL logic to get that data.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24459/need-sql-logic-to-get-data-from-last-bip-report-scheduled-date

Hi Ranjith,

I wrote a query to extract these details. Please check the query on below link and you can use it accordingly as per your need:

https://fusionhcmconsulting.com/2025/01/bip-report-to-extract-bip-scheduled-jobs/

Thanks.

Ranjith1166

Thanks Mandeep