Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics & AI Challenge
- 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
