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...
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 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 Obiee Dashboard Prompt Bip Parameter Relation
OBIEE 10G - BIP report integration

Oracle BI Publisher creates highly formatted, printable reports. Oracle BI Publisher is integrated with Oracle Business Intelligence, and you access Oracle BI Publisher from the : Oracle BI Answers,...



Share this page:
Follow us:
Task Runner