Categories
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Allow SQL in Agent Parameters

MaartenDIF
Rank 4 - Community Specialist
Description
We want to be able to run OTBI reports scheduled with agents with parameters that are based on SQL.
We want to run a scheduled OTBI report with an as-of date of SYSDATE + 30 days. We can do this by adding a parameter in the prefix of the advanced SQL tab. However, it is not possible to make an agent pass a parameter based on SQL.
I've opened a SR for this issue, but Oracle confirmed it is currently not possible to do this
Use Case and Business Need
The reason we want an as-of date in the future is because the report must include new hires, but not include expiring contracts. For this reason we cannot just set the date in the far future.
Original Idea Number: d3d5561de2
1