OBIEE - Where can I use a presentation variable ?

About

You can reference presentation variables in the following areas :

  • Answers :
    • Title Views
    • Narrative Views
    • Column Filters
    • Column Formulas
    • Conditional Formatting conditions
    • Chart scale markers.
    • Gauge range settings.
    • Static text.
  • iBot Headlines and text

Some examples are given below with a presentation variable “Year” and as default value the max of the year :

@{Year}{max(Calendar."Calendar Year" by) }

A prompt has been first created to set the presentation variable : OBIEE 10G/11G - How to set a presentation variable ?

Answer

Formula Column

You can also set it in a formula. Example :

CASE 
   WHEN @{Year}{max(Calendar."Calendar Year" by) } = '2001' THEN 'It''s the year 2001' 
   ELSE 'You choose an other year' end

or

CASE  
WHEN  @{Year}{max(Calendar."Calendar Year" by) } <  Calendar."Calendar Year" 
   THEN 'The Year is greater than the presentation variable ' || 
       cast(@{Year}{max(Calendar."Calendar Year" by) }  as char)   
WHEN @{Year}{max(Calendar."Calendar Year" by) } =  Calendar."Calendar Year" 
   THEN 'The Year is equal to the presentation variable ' || 
       cast(@{Year}{max(Calendar."Calendar Year" by) }  as char)  
ELSE 'The Year is smaller than the presentation variable ' || 
      cast(@{Year}{max(Calendar."Calendar Year" by) }  as char) end

Filter

Title View

OBIEE - Title View

Static Text View

OBIEE - Static Text View

Conditional Formatting

OBIEE 10G/11G - Conditional Formatting

Dashboard Object Text

You can also use a presentation variable in a dashboard text object.


Powered by ComboStrap