OBIEE - Presentation Variables

Saw Object

About

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 (with a dashboard prompt, with a javascript, …)

With a dashboard prompt, it will take the data type of the presentation column.

The presentation variable can be referenced in various areas of presentation service (such as answer and dashboard).

In OBIEE, you have also as variable the OBI server variable that are managed by the oracle BI Server

Syntax

The syntax for referencing presentation variables is as follows:

@{variables.<variableName>}{<default>}[format]
  • variables - (optional)
  • variableName - a reference to an object available in the current evaluation context that is not a reserved variable name
  • default - (optional) - a constant or variable reference in Obiee logical sql indicating a value to be used if the variable referenced by the variableName is undefined as :
    • for a string : 'String'
    • for a number : 3
    • for a date : date 'YYYY-MM-DD'
  • format - (optional) - a format mask dependent on the data type of the variable.

For example: :

  • #,##0,
  • MM/DD/YY hh:mm:ss.

More format example : Using Custom Date/Time Format Strings in Oracle BI Answers

Example

  • @{myFavoriteRegion}{'Central'}
  • @{myFirstDate}{DATE '1973-07-24'}
  • @{myFavoriteString}{'Nico'}
  • @{myYear}{max(Time.Year)}

Obiee Presentation Variable Date Format

More : OBIEE - Where can I use a presentation variable ?

What is the scope of a presentation variable ?

The scope of a presentation variable (as a request variable) depend of the prompt scope.

For instance in the dashboard prompt definition:

Obiee Dashboard Prompt Scope

Then you can use it exclusively in a dashboard and not for the entire session. For instance, if you leave the dashboard by opening a new report or going into an other dashboard, the value will be reinitialized to the default value defined in the syntax.

Reference





Discover More
Obi Edition
OBIEE - All type of variables

OBIEE offer several variables which can be set : variables from the OBIEE Server known as session and repository variables. This kind of variable can be initiate with the help of SQL statement and...
Obiee Variable Manager
OBIEE - BI Server Variables (session and repository)

The OBI Server can handle two types of variable : repository variable: constant or refreshed periodically session variable: depend of the user and are then set up during the login process. system...
Column Formula
OBIEE - Criteria Tab

The criteria tab of an answer is a GUI that help you to create the logical SQL. In a column formula, you can add: comment a presentation column a presentation variable a bi server variable...
Obiee Filter On Date
OBIEE - Date Format in presentation variable, dashboard prompt and logical SQL

This article talk the manipulation of a presentation variable with a date datatype. Starting with OBIEE 10.1.3.4.1 and higher versions, Dashboard Prompt input formats and presentation variable values...
Obiee Answers Advanced Sql Clauses
OBIEE - How and where can I set a Request variable (SET VARIABLE) ?

A request variable is an OBI Server Session Variable but with the scope of the request. The value of the session variable will not be change for the session. You can set it up in three main ways : ...
Obiee Presentation Service System Variable
OBIEE - Presentation Variable System (reserved variable)

The presentation service has some presentation variables that are reserved to give specific information. You can use them in your answer such as @{system.currentTime} to filter depending of the current...
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 Database Request Subject Area
OBIEE 10G/11G - Direct Database Request

The Direct Database Request permit you to perform SQL statement directly to a datasource. The Oracle BI Server sends unprocessed, user-entered, physical SQL directly to an underlying database. The returned...
Obiee Setting Presentation Variable
OBIEE 10G/11G - How to set a presentation variable ?

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 : Which means: use...
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