Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Dynamic Prompt Value Change in Column Heading using Request Variable in OBIEE
Hi Team,
Am Using OBIEE 11g version. We have a prompt which is Variable Prompt with Request Variable using few custom values.
When ever user selects the Column value from the Prompt(Request Variable) ,that value pass to my column heading in the Report. It behave as Dynamic Column Heading changes as when ever user switch one value from another in the Prompt selection those value should pass to my Report heading.
Can some one guide or tell the work around to achieve this requirement.
Thanks for your help and support in advance
Answers
-
You’ll need to provide further information for any assistance. Where are you trying to pass this prompt value to? Is it a title? A column heading?
a screenshot or 2 may be helpful.
0 -
Hi Joel, Thanks for the response.
I want Pass this Prompt value to Column Heading in the Report. The Prompt which i have created its a Request Variable.
0 -
Are you looking for this?
https://obieenow.blogspot.com/2014/03/dynamic-column-headers-obiee-11g.html
0 -
Thank you for the response.
Here am using my variable Type as Request variable in the Prompt. I can achieve my requirement using Presentation Variable but i want to use Variable Prompt as Request Variable.
0 -
Are you using the right syntax?
A request variable is a way to set the value of a session variable. So you need to use the right syntax to reference it ...
https://gerardnico.com/dat/obiee/obis/server_variable_where#logical_sql_in_answers
0
