OBIEE 10G/11G - How to set a presentation variable ?

Saw Object

About

You can set up a presentation variable:

  • only through the user interface
  • programmatically with javascript is not yet supported

And you can use it then in many places : OBIEE - Where can I use a presentation variable ?

Syntax

@{MyPresentationVariable}{MyDefault Value}

Example

@{myYear}{max(Time.Year by)}

Which means:

  • use the presentation variable myYear
  • and if it's not yet set then use as default the maximum year of the data set.

Multiple value / select

  • OBIEE 10g: You cannot set a Presentation Variable in a Multi Select dashboard prompt in OBIEE 10g. This is expected behavior. OBIEE 10g is working as designed. A Presentation variable can assume a single value. Because of that, presentation variables are not available when using multi select prompts. See note 965224.1
  • OBIEE 11g will introduce the ability to set Presentation Variables when using multi select prompts. In 10g you can try as a workaround using more than 1 prompt.

How to set it up

With the user interface

In 10G, the dashboard prompt is the only way to set a presentation variable. With the advent of 11G, you can now set a presentation variable with the help of a variable prompt

When the dashboard or variable prompt is used in a dashboard, the variable is simply set with the new value.

Dashboard prompt

When you create a dashboard prompt, you have in the column “set variable” the choice between two values :

  1. Select in the Set Variable Column, the value “Presentation variable”
  2. Enter a name for your presentation variable

10G

Obiee Setting Presentation Variable

11G

Variable prompt

variable prompt

With Javascript

This functionality does not exist at the moment.: OBIEE 11g: How To Set the Value of a Presentation Variable Using Javascript





Discover More
Obiee Presentation Variable Date Format
OBIEE - Presentation Variables

The presentation variable is the only variable offer by the presentation service. You can use direct some system presentation variable (pre-populate or system presentation variable). You can set it up...
Obiee Topn Global Scope
OBIEE - TopN

The TopN function in OBIEE permit to perform a TopN analysis. The TOPN function operates on the values returned in the result set. When you add it as a formula column in an answer, the data are automatically...
Obiee Presentation Variable Formula Column
OBIEE - Where can I use a presentation variable ?

You can reference presentation variables in the following areas : Answers : Title Views Narrative Views Column Filters Column Formulas Conditional Formatting conditions Chart scale markers....
Obiee 10g Server Variable Session Repository
OBIEE 10G/11G - The (dashboard|column) prompt

The dashboard prompt is the most used prompt to filter rapport in a dashboard but it can also set: a presentation variable variable prompt a request variable In 10g, for a repository...



Share this page:
Follow us:
Task Runner