OBIEE - How to constraint the values of a dashboard prompt based on the selection of an other ?

Saw Object


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, and Constrain is checked for District, the values shown in District will be limited by the values entered in Region and Year.


How to

  • Select your two columns that you want to add to your dashboard prompt,
  • then check the check box below :

Obiee Prompt Constrain

The result

Obiee Prompt Constrain Result


Then in the session manager, you can see that three OBIEE logical Sql are fired :

SELECT Products."Prod Category" FROM SH ORDER BY 1 
SELECT Products."Prod Subcategory" FROM SH ORDER BY 1
SELECT Products."Prod Subcategory" FROM SH WHERE Products."Prod Category" = 'Electronics' ORDER BY 1

Discover More
Obiee Implicit Fact Column
OBIEE - Implicit Fact Column

You can find this functionality in the general property of a subject area in the repository. The goal of this definition is to guide the BI Server to make the best choice between two possibles query path:...
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