Editing Report Prompts in PowerPoint

If the report contains prompts, you can choose to continue with the default prompts or change the prompts when importing or inserting reports in PowerPoint.

Prompt labels are defined while designing reports. Report designers give meaningful labels such as "Select a reporting region" or "Select a quarter" so that users can understand and select the prompts correctly. While inserting a report in Oracle Smart View for Office, if the report contains prompts, then the Select Prompts dialog lists the available prompts and users can select the required ones before inserting the report.

The prompts are categorized and displayed under prompt labels instead of dimension names in the Select Prompts dialog. This becomes helpful, especially when prompts belong to the same dimension. In such cases, prompt labels enable users to distinguish between the prompts easily.

Editing the prompt reloads the formatted report in the sheet.

To edit the prompts for a report in Excel:

1. Insert the report.

   If the Select Prompt dialog box appears while you are inserting the report, continue with step 3. If you have already inserted the report and now want to edit the prompts, continue with step 2.

2. In the Smart View ribbon, click Edit Prompts.
3. In the Select Prompt dialog box, click next to a prompt to select the required members for the prompt from the Select dialog box or the Member Selection dialog box.
4. In the left pane, select one or more members and click to move members to the right pane.

   If no choice list is defined, then the Member Selection dialog box is displayed.

   If a predefined choice list that uses the Descendants() or Descendants(Inclusive) function is defined for the dimension, then the choice list is displayed in hierarchical format in the left pane of the Select dialog box. Selected members are shown in a flat list in the right side of the dialog box.

5. Optional: You can also do the following:
   • To remove a selected member, select the member in the right pane, and click to move it to the left pane.
   • You may enter search terms into the search text box, and then click the Search button to filter the results in the left pane.
   • You can select multiple members only if the report prompt is configured for multiple member selection.
   • You may switch the display in the left pane to a flat list, and back to a hierarchy, as required, using the Show Hierarchy check box. Note that in the Hierarchy view, you cannot select multiple members at once to move to the right pane.
6. After moving the required members to the right pane, click OK to return to the Select Prompt dialog box.
7. Similarly, make the selections for the other prompts, as required.
8. Click OK in the Select Prompt dialog box.
   The report is reloaded in the slides as per the selected prompts.