OBIEE Variables

You can reference variables in several areas of OBIEE, like analyses, dashboards, KPIs, actions, agents, and conditions. For example, suppose that you wanted to create an analysis whose title displays the current user’s name. You can do this by referencing a variable.

OBIEE has 4 types of variables:

  • Session
  • Repository
  • Presentation
  • Request

Session Variables: A session variable is initialized at login time for each user. When a user begins a session, the BI Server creates a new instance of a session variable and initializes it. There are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each instance of a session variable could be initialized to a different value. Session variables are also of two types:

  • System — A system session variable is used by BI Server & Oracle BI Presentation Services for specific purposes. System session variables have reserved names that cannot be used for other kinds of variables.
  • Non-system — A non-system variable that the administrator creates and names. For example, the administrator might create a SalesRegion non-system variable that initializes the name of a user’s sales region. The administrator creates non-system session variables using the OBI Admin Tool.

Repository Variables: is a variable that has a single value at any point in time. The administrator creates repository variables using the OBI Admin Tool. There are two types of repository variables:

  • Static — variables whose value persist and do not change until the administrator decides to change them.
  • Dynamic — variables whose values are refreshed by data returned from queries.

Presentation Variables: is a variable that you can create as part of the process of creating one of the following types of dashboard prompts:

  • Column prompt — A presentation variable created as part of a column prompt is associated with a column.
  • Variable prompt — A presentation variable created as part of a variable prompt is not associated with any column.

Request Variables: lets you override the value of a session variable but only for the duration of a database request initiated from a column prompt. You can create a request variable as part of the process of creating a column prompt. A request variable that is created as part of a column prompt is associated with a column, and the values that it can take come from the column values.

Where Can I Reference Variables? You can reference variables in the following areas:

  • Title views.
  • Narrative views.
  • Static text views.
  • Filters.
  • Column formulas.
  • Conditional formatting conditions.
  • Table and column headings in analyses.
  • Direct database requests.
  • Dashboard prompts and inline prompts.
  • Headers and footers for PDF output.
  • Link or image objects in a dashboard.
  • Text objects in a dashboard.
  • Graphs to specify conditional formatting of graph data.
  • Gauge thresholds.
  • Gauge limits.
  • Agents.
  • Actions to specify parameters.
  • Conditions to specify parameters.
  • Selection steps.
  • KPIs to define thresholds.
  • KPIs included in a KPI watchlist.
  • URL fields in dialogs.

Note: In syntax, if the “at” sign (@) is not followed by a brace ({), then it is treated as an “at” sign.