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 Oracle Fusion Forecast Management database connection), or aliases (for Analytic Services or Oracle Hyperion 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,
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:
- In Oracle Hyperion Enterprise Performance Management Workspace with the BI Catalog open, right-click a Oracle Hyperion Financial Reporting book, and the select Open in Editor.
- In the Book Editor, right-click a document in the book, and then select Member Selection.
- In the Preview User Point of View dialog box in the Members tab, select Prompt for <member>, and then click OK.
- 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.
- 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.
- 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:
- Click OK.