.
Some prompted reports require you to define your filtering conditions based on a metric. These are metric Prompts , in which you create a filter for a metric to define the data that is displayed on the report.
If you attempt to run a report that contains a required prompt without answering the required prompt, the report will not run, and a message stating this requirement is displayed.
To answer a prompt by defining a filter based on a metric:
Click the name of a prompted report to run it. A prompted report will present a prompt question to be answered before the report data is displayed.
If the prompt already has an answer (a filtering condition) in the right pane, you can do one of the following:
Change the existing answer (filtering condition) using the information in the next step.
Add other answers (filtering conditions) to it using the information in the next step.
Click Next and proceed to answer other prompts, or if this was the only prompt, you can run the report or document.
If the prompt does not have an answer in the right pane, or you want to add to or change answers (filtering conditions), create your filter by performing all of the following:
Click in the right pane to start creating your filter.
If you want to select an output level, click ... (browse) next to the Output Level field to select a level. The output level is the level at which the metric results are calculated. The default is the metric’s level.
Depending on how the prompt’s creator designed the prompt, you may be able to select the metric on which you want to base your filter. Use one of the following methods:
Enter the name of the metric in the Metric field and click OK.
Click ... (browse) to locate the metric. In the Open dialog box, navigate to the folder that contains the metric, select the metric, and click OK.
From the Function drop-down list, select the part of the metric that will be filtered on: Metric Value, Rank, or Percent.
From the Operator drop-down list, select a logical operator. For example, you might choose the Greater Than operator to filter out data that is below a certain number.
Beside the Value field, enter the value to complete your chosen operator. For example, if you chose the Greater Than operator above, you must enter the value which data should be greater than, to be returned on the report.
Click OK to close the Set Qualification pane.
When you are finished defining your filter, if there is another prompt on the report or document scroll down or click Next to answer the next prompt. Use the appropriate steps to answer them.
When you are finished answering all prompts, review the summary of your answers and click Run Report or Run Document. The report or document is executed and your results are displayed.
If you want to save and reuse your answers, see Saving and reusing prompt answers.
If you want to see how your prompt answers were used to create the report’s filter, select Report Details or Document Details from the File menu. Your prompt answers appear in the form of report filtering conditions. You can also see whether a cache was used to supply the results. If a cache was not used, the results were taken from the latest data in your data source.
To see data filtered in a different way, click the Re-prompt icon .
Answering a prompt by selecting answers from a list
Answering a prompt by typing a specific value
Answering a prompt by defining a filter based on an attribute
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices