Setting Up Report Prompts

A prompt is a way of assigning members to a dimension. The prompt is set up during design time. As a report designer, you can limit the type of data to assign to a dimension. You can also specify whether the Respond to Prompts dialog box displays member names, descriptions or aliases, or both member names and descriptions or aliases.

For example, you could create a report that enables the user to select from lines of products. The report designer selects Prompt as a member of Product, and then selects specific product lines. The person who runs the report then selects from those product lines.

To set up a report prompt for members:

1. Open a report and select a grid.
2. Double-click the dimension cell for which you want to assign a prompt.
3. In the Select Members dialog box, on the Members tab, select Prompt for <dimension name>, and then click to select it.
4. Click OK.
5. In the Define Prompts dialog box, enter the following information:

   • Title—Enter the title for the prompt.

     For example, for a "Measures" dimension, you could say "Enter Measures".

   • Default Member—Enter the member to use as the default member, or click to select the default member. If you specify multiple members as the default, separate the members by commas.

     If you leave Default Member blank, the Respond to Prompts dialog box does not display a default member when you run the report or create a batch.

   • Choices List—Click to select the member or members available as choices when responding to the prompt. If you specify multiple members in the choices list, separate the members by commas.

   • Select which labels to display in the Respond to Prompts dialog box when you run the report (Member Name, Alias, or Member Name and Alias).

6. Click OK.