Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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
