Dynamic Prompt Value Change in Column Heading using Request Variable in OBIEE

Vijay KVB

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

Joel

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.

Vijay KVB

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.

Gianni Ceresa

Are you looking for this?

https://obieenow.blogspot.com/2014/03/dynamic-column-headers-obiee-11g.html

Vijay KVB

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.

Gianni Ceresa

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

OBIEE: Using Variables in OBIEE