Categories
- All Categories
- 149 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How can I use session variables with a report BIP?

João Castelhano
Rank 1 - Community Starter
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
0
Answers
-
You can able to override the value using pl/sql package (use before trigger)
Regards,
Arjun
0 -
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.
0