A prompt is a way of enabling the viewer to assign 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 (for a Financial Management database connection) or aliases (for Oracle Essbase or Planning database connections), or both member names and descriptions or aliases.
For example, you might create a report that enables the user to select from lines of products. The report designer selects Prompt as a member of Product, then selects specific lines of product. The end user who runs the report selects from those product lines.
To set up a report prompt for members:
Optional: To limit the prompt selection to specific default members, or a list of members, or both, take an action:
If the member name is known, enter the member name in Default Member or click the Default Member search button. If multiple member are provided for the prompt, members must be separated by commas. For information on selecting members, see Assigning Members to Data Rows or Columns.
If the list of members is known, click the Choices List button to select a list of members. If multiple member lists are provided for the prompt, member lists must be separated by commas. For more information, see Defining Member Lists.
From the Member Labels in Prompt Selection Dialog drop-down list, select the kinds of labels to be displayed in the Respond to Prompts dialog box when the report is run:
If the database connection is Oracle Essbase or Planning, select Member Name, Alias, or Member Name and Alias.
If the database connection is Financial Management or SAP BW, select Member Name, Description, or Member Name and Description.
If the database connection is SAP BW, select Member Name, Description, or Member Name and Description.