Prompts

Dashboard Prompt

With the help of prompt we are applying filters to the reports dynamically at run time.

Lets see how to create  Dashboard Prompts:

Click New and Select Dashboard Prompt. 

Once the dashboard prompt is selected, It would prompt to select the Subject area for which dashboard prompt has to be created.

After selecting the subject area, the following screen appears:

In OBIEE, there are three types of Dashboard Prompt:

1) Column Prompt

2) Variable Prompt

3) Image Prompt

Column Prompt :  A prompt is created on a column (dimension attribute). With column prompt following can be done :

1) Prompt for column
2) Operative filter can be set.
3) It holds only column values
4) is prompted filter can be applied.
5) Presentation and Request Variable can be created.

 The following has to be set for a column  prompt:

Column - Refers to the Dimension for which prompt is created.

label - Name of the prompt

Operator - what kind of filter should be applied to the selected dimension attribute (equal to/greater than/between etc)

User Input - to set the type of prompt (check boxes, choice list, list box, radio button &slider etc)

Choice list values - to set the value that a prompt should hold (all column values, specific column values, members of group, all column values and specific member of groups)

Default Selection - specifies the value that a prompt should hold by default (None,specific values, variable expression, SQL results and server/repository variable)

Set a Variable - The values selected by the user at run-time can be assigned to a variable that is defined in this section (None, Presentation Variable and Request Variable)

Note :

1) With column prompt, only one filter condition can be applied to a column.
2) It cannot have user defined values in its choice list.
3) Data type of the variables cannot be changed.

Variable Prompt : A prompt is created using a variable. The values of the prompt can hold a column value or custom value ( a user defined value). User can set the data type for the variable values. The presentation variable (Sel_Year) will hold the values selected in the prompt. The following can be done with the help of Variable Prompt:

1) Prompt created for presentation Variable.
2) It can hold column values/ user defined values.
3) Filter is applied to the report using presentation variable.
4) Presentation variable can be created.
5) Prompt can be defaulted to a value.

Prompt for  - Presentation variable name has to be given , which will be created with the execution of prompt. 

label - Name of the prompt

User Input - to set how the prompt type (check boxes, choice list, list box, radio button &slider etc)

Choice list values - to set the value that a prompt should hold (all column values, specific column values, members of group, all column values and specific member of groups)

 Variable Data type:

 Default Selection - specifies the value that a prompt should hold by default (None,specific values, variable expression, SQL results and server/repository variable)

Note :

1) With variable prompt, operative filter cannot be applied.
2) Request variable cannot be created.
3) isprompted filter condition cannot be applied.