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 ?
Articles Related
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
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.