Working with Page Prompts

Page prompts enable users to specify criteria that determines the content of the view that has been inserted. Oracle Smart View for Office supports both page prompts and prompts. See also Working with Prompts.

Page Prompts in Smart View are the equivalent of view prompts in Oracle Business Intelligence Answers. View prompts are specified on individual views within an analysis. Smart View supports table prompts, graph prompts, and gauge prompts in BI Answers; these types of prompts are called page prompts in Smart View.

Page prompts may vary on individual views within an analysis. An individual table view within an analysis may have a page prompt set on Year, and a pivot table view within the same analysis may have a page prompt set on Line of Business.

When you first insert a view that contains page prompts, a view state is selected by default. For example, if a prompt on Year is specified on a particular view within an analysis, and the years 2010, 2011, and 2012 are available to choose from, you are not prompted for these at the time of insertion. Instead, a default state of the view is inserted. For example, 2010 data may automatically be inserted, as the first year in the list of years available. You can then edit the page prompts to select another year's data to display for this view.

You may edit page prompts in views that have been inserted, or copied and pasted.

To edit page prompts:

  1. From the worksheet, select a view:

    • Graph views—Select the graph.

    • Table and pivot table views—Select any cell in the table.

  2. From the Oracle BI EE ribbon, select the Edit Page Prompts button to display the default page prompt selections for a particular view.

    Figure 19-13 Edit Page Prompts Button


    Edit Page Prompts button

    If the report definition has changed on the Oracle Business Intelligence server, your selections are reset, and you must select all page prompts again.

  3. In the Page Selector, modify the page prompt selections by selecting from the drop-down lists.

    Figure 19-14 shows a Page Selector dialog box, where users select a Year and a Line of Business. In the example, selections were made to display 2010 for the year, and Electronics for the Line of Business.

    Figure 19-14 Filled-in Page Selector


    A filled-in Page Selector dialog box. The year 2010 and the Electronics Line of Business are selected for display.
  4. Click OK to close the Page Selector.

    After you make selections and click OK, the view is immediately refreshed and reflects your selections.

  5. Repeat this procedure to edit the page prompts to change the output displayed.