How can I use session variables with a report BIP?

João Castelhano

I built a Report (BIPublisher) using a subject area table, which is created in the physical layer with a sql query with session variables in the where clause.
Is it possible to change the values of these variables on the Report?
Thanks

Mallikarjuna Kuppauru-Oracle

Hi @Joao Carlos Monteiro

You can able to override the value using pl/sql package (use before trigger)

Regards,

Arjun

João Castelhano

@Mallikarjuna Kuppauru-Oracle

The objective is to create a dashboard with a report (BI Publisher) abnd a dashboard prompt.

Through the dashboard prompt, pass values to the session variables in the rpd. Similar to what is done with an Analysis.