Creating a mandatory field in page-level prompts

The following example lists the steps required to make the Product Group prompt as a mandatory prompt:

1. Login to the Oracle Business Intelligence Enterprise Edition application as a user with administrative rights and access to edit the dashboards. Typically, this would be the administrator.

   Figure 6-1 Dashboard Reports

   
2. Navigate to the folder in the catalog where prompts are saved. Example: Catalog > Shared folders > Retrospective > Case Processing History.
3. Click the Edit link to make the change. Example: CP History Page Prompts.

   Figure 6-2 Oracle Business Intelligence Enterprise Edition Objects in Catalog Folders

   
4. Select the field which is to be made mandatory and click the Edit icon (present on the top right of the opened screen), such as the Product Group field selected below.

   Figure 6-3 Catalog Prompt Edit Page

   
5. An Edit Prompt dialog appears, with options to customize the prompt. To make the field mandatory, check the Require user input checkbox and click OK.

   Figure 6-4 Edit Prompt Dialog

   
6. You can verify the change by checking the Required column of the field (Product Group below). Mandatory fields have a tick mark displayed against them. In the Preview window, an asterisk (*) appears before the name of the mandatory field.

   Figure 6-5 Preview Changes in Dashboard Prompts

   
7. Save the prompt by selecting the Save icon (highlighted below), present on the top right side of the screen.

   Figure 6-6 Saving Dashboard Prompts

   
8. The column configured for mandatory input is now reflected in the page-level prompt of the respective reports.

   Figure 6-7 Mandatory Prompts Marked with * in Report Page

   

   Note:

   The Apply button is disabled. This button will get enabled only after values for all the mandatory prompts present in a page have been entered. The text * Indicates mandatory field is displayed next to the mandatory prompts present in a page.