Schedule BIP Report with dynamic parameter values
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.