BI Publisher (MOSC)

MOSC Banner

Schedule BIP Report with dynamic parameter values

edited Mar 1, 2016 4:27PM in BI Publisher (MOSC) 6 commentsAnswered ✓

Hello everyone,

got a report with a some parameters.

This value is retrieved through a SQL query that will only return one ID_PERIOD value which is then used to filter the data model.

However, this value depends on a table populated by users, where they change this ID_PERIOD each week.

I see that when the job was created, it was saved with the ID_PERIOD value at that time.

Is there any way that each time the report runs, it will take the current value of ID_PERIOD and not the first one when job was created?

I was even thinking on make things complicated, like using a PL/SQL procedure to call a BIP Web Service, so the ID_PERIOD value is checked on execution by a SQL query in  the PL/SQL procedure, but I would definitely prefer something easier.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center