Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Allow SQL in Agent Parameters

1
Views
0
Comments
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
1 votes

Submitted · Last Updated

Welcome!

It looks like you're new here. Sign in or register to get started.