Working with Table Prompts

Prompts enable a report viewer to select the members in a table when they run the report.

To define a prompt:

  1. Open a report and select a table.
  2. Click the filter iconicon, then select Filter Criteria, and then click edit con. Optionally, you can also open the Select Members dialog box from a report if you right-click a dimension from the table and click Select Members.
  3. In the Edit Filter Criteria dialog box, select an attribute, operator, and then from the Functions list, select Prompt.
  4. To enter a value for Prompt from the suggested list, click edit icon .
    Edit Prompt screenshot

  5. In Prompt Label, enter the prompt text that is presented to the users.
  6. In Choice List, select the members that are available to the users. The considerations include:
  7. (Optional) In Default Selection, select the member or members that are listed as the default for the prompt. If Allow Multiple Selections is disabled, you can select only one default member.
  8. Click OK.