Limiting the Members That Can Be Selected

You can limit the members that can be selected for a book. You can also specify an alternate member label, 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, to provide only lines of products, In Member Selection, 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.

Note:

The following steps work only for books that contain reports with dimensions on the POV in the report

To set up a report prompt to select members::

1. From the Explore Repository, right-click a Oracle Hyperion Financial Reporting book, then select Open In, and then Editor.
2. In the Book Editor, right-click a document in the book, and then select Member Selection.
3. In the Preview User Point of View dialog box in the Members tab, select Prompt for <member>, and then click OK.
4. Optional: To limit the prompt selection to specific default members, a list of members, or both, do the following:

   • If the member name is known, enter the member name in Default Member or click Default Member. If multiple members are provided for the prompt, members must be separated by commas.

     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 members are known, click Choices List to select a list of members. If multiple member lists are provided for the prompt, member lists must be separated by commas.

5. From Member Labels in Prompt Selection, select the kinds of labels to be displayed in the Respond to Prompts dialog box when you run the report:
6. Click OK.