OBIEE 10G/11G - The (dashboard|column) prompt

Saw Object

About

The dashboard prompt is the most used prompt to filter rapport in a dashboard but it can also set:

Default selection

Server variable

In 10g, for a repository variable and a session variable

Obiee 10g Server Variable Session Repository

Variable expression

To set a presentation variable as default.

Obiee 11g Dashboard Prompt Variable Expression

Operators

Between

You can make a between filter

  • with the between operator (Both limits are not required)
  • with two presentation columns with the same logical column but with two different names.

Documentation / Reference





Discover More
Saw Object
OBIEE - BI Presentation Service (SAW/OBIPS)

AnswersInteractive DashboardsDelivers The Oracle BI Presentation Service Server: is a pure Web Environment visualize data from the Oracle BI Server through the creation of Interactive Dashboards...
Saw Object
OBIEE - Dashboard Prompt with data level security

Example of dashboard prompt with a data level security. session variablerow-wise Logical SQL Result : Logical SQL Result :
Obiee Parameter Prompt Result
OBIEE - Dashboard parameter prompt - The WHEN 1=0 or ifnull solution

You may need to create a dashboard prompt to set a presentation parameter (as for the hierachy level) to change the behaviour of your dashboard. The dashboard prompt is based on the column of a subject...
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 Prompt Constrain
OBIEE - How to constraint the values of a dashboard prompt based on the selection of an other ?

What means the constraint check box in a dashboard prompt ? Constrained columns will be constrained by all other columns in the prompt. For example, if the prompt contains columns Year, Region, and District,...
Obiee Session Non System Repository Variable
OBIEE - How to set a server variable with the session type via a dashboard prompt (with a request variable) ?

A common way to set up a request variable in order to set a session repository variable is to create a dashboard prompt. This article show you with the help of the sh schema a little example. The goal...
Obiee Ceim
OBIEE - Logical Sql

The logical SQL is the SQL that understand BI Server. It's a full Ansi 92 SQL (including subqueries and derived tables), plus special functions (SQL extensions) like AGO, TODATE, EVALUATE, and others....
Saw Object
OBIEE - Prompt

In OBIEE, you have two type of prompt to be able to filter information or set variables: the answer prompt the dashboard prompt the variable prompt (from 11g)
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...



Share this page:
Follow us:
Task Runner