Using Presentation Variable in OBIEE

To use the Presentation variables in Title,Subtitle,Narratives,fx of any reports the syntax  is - @{variable_name}.

Presentation Variable in Title view : 

 Presentation Variable in Narrative view : 

                                         

But we should consider two things while using the variable in fx of request.

                                        

The Presentation Server replaces the variable name with the value associated with that variable (value selected in prompt).

So, when the variable is returning character type value, then the variable name must be enclosed in single quote. When the variable is returning numeric type value, then the variable name must not be enclosed in single quote.

When the variable is returning CHAR type value -

                                         

When the variable is returning Numeric type value - 

                                     Note :   

  Make sure that when a presentation variable is returning char type value, we should enclose it in single quote, otherwise the presentation services treats its value as logical  column name. If you have any logical column with that name then there would no issue. Otherwise you will get an error like -  Unresolved column.