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

Ranjith1166 · Jan 30, 2025 11:21AM

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 · Jan 30, 2025 5:45PM

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:

Thanks.

Ranjith1166 · Mar 21, 2025 7:12AM

Thanks Mandeep

Oracle Business Intelligence Applications Forum