Editing Prompts in Reports

If the report contains prompts, you can choose to take the default prompts when importing or inserting, or change the prompts.

To choose the default prompts, click OK in the Select Prompt dialog.

To edit the prompts, use the procedure in this topic.

Note:

Before you begin:

• You should have completed steps 1 through 3 in Importing or Inserting, and Working with Fully Formatted Reports.

• Save the workbook if there are changes that you want to keep. The workbook will be closed and regenerated when you edit prompts.

To edit the prompts for a report:

1. To edit the prompts when importing or inserting the report, in the Select Prompts dialog, perform an available action:

   • Use the check boxes to select members for each prompt.

   • Click the ellipsis button, to launch the Member Selection dialog. In the left pane of the Member Selection dialog, expand the members where necessary, then select one member and click to move it to the right pane, and then click OK to return to the Select POV dialog.

     Note:

     Be sure to choose only one member in the Member Selection dialog.

   The sheets in the resulting workbook will appear in alphabetical order, just as they were listed in the dialog. You can manually reorder the Excel worksheets, if required.

2. To edit the prompts after the report is imported or inserted:

   1. In the Smart View ribbon, click Edit Prompts, .

   2. Repeat the actions noted in step 1 for each prompt that you want to edit, and then click OK to import the report.

   Note:

   Editing prompts reloads the formatted report.