OBIEE - Where can I use a presentation variable ?

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Presentation Service (SAW/OBIPS)

1 - 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 ?

Advertising

3 - Answer

3.1 - 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

3.2 - Filter

3.3 - Title View

3.4 - Static Text View

Advertising

3.5 - Conditional Formatting

3.6 - Dashboard Object Text

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