Prompt Details allows you to limit the members that can be selected for a book. You can also specify an alternate member label; a descriptions (for a Financial Management database connection) or aliases (for Analytic Services or Planning database connections), or both member names and descriptions or aliases. For example, if you want to only provide lines of products, In Member Selection you would select Prompt for Product as a member of Product, then in Prompt Details select specific lines of product. The user who runs the report selects from those product lines.
To set up a report prompt for members:
After selecting Prompt for... on the Members tab of the Member Selection dialog, and clicking OK, the Prompt Details dialog is displayed.
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.
Note:
If you leave Default Member blank, the Respond to Prompts dialog box does not display a default member when a user runs the report. The user must specify a member rather than accept a default.
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.
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 Analytic Services or Planning, select Member, Alias, or Member - Alias.
If the database connection is Financial Management or SAP BW, select Member, Description, or Member - Description.