Table of Contents

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.
  • Direct Database Requests
  • Dashboard prompts
  • 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 : Presentation Variable Initialization

Answer

Formula Column

Obiee Presentation Variable 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

Obiee Filter Presentation Variable

Title View

Title View

Obiee Presentation Variable Date Format

Static Text View

Static Text View

Obiee Static Text Presentation Variable

Conditional Formatting

Conditional Formatting

Obiee Column Format Conditional Presentation Variable

Dashboard Object Text

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