Define a query for an interactive report definition

A query-based interactive report has a query associated with it. When the user runs the report, the user specifies values for the variables in the query. The application then runs the report against cases that meet the criteria of the query.

1. In the left navigation pane, hover on the Data Analysis icon ( ), then click Interactive Reports.
2. Click Create Definition.
3. From the Configuration drop-down list, select a data configuration to indicate the source data on which to base the report. You can click Browse to select from a descriptive list of data configurations.
4. In the Name field, type a report name. The name does not need to be unique, although Oracle recommends that you provide a unique and meaningful name.
5. In the Description field, type a description that differentiates the report definition from others on the Interactive Report Definitions page.
6. Assign the report definition to a project.
   • To assign the report definition to an existing project, click Add to existing project and select from a list of projects associated with objects that you created or that are published to you.
   • To create a new project and assign the report definition to it, click Add to a new project named and enter a project name.
7. Click Save.

   The Edit Report Query page appears. You can also display the page by clicking Query on other pages of the interactive report definition.

8. To create a new query, choose one of the following:
   • To use the Query Wizard, click Create Using Query Wizard.

     The Define Query page appears. For more information, see Defining a query.

   • To create a query based on an existing query, click Create from Existing Query.

     The Select Query from Library page appears. Subsequent changes to the query in the library do not affect the report. For more information, see Defining a query.

     The defined query appears on the Edit Report Query page in the Query field.

   Note:

   If you saved the query to the library and then you edit from this page, your changes are not saved to the library. If the query includes a variable that you want to use as a breakdown variable in the report, remember to set up the breakdown details to use query values.

Breakdown details

If you want user-specified values from a query to be used as breakdown details for a report column or row, you must do both of the following:

• Include the breakdown variable in the query.
• Specify Query Values for the variable's breakdown details.

If you set up a breakdown variable to use query values but you do not include the variable in the query that is part of the report definition, the application cannot determine the breakdown values. If a column or row variable has no breakdown values, the application drops it when running the report. If this results in a report without rows or columns, the report cannot be run.

If you include a breakdown variable in the query but do not set up the breakdown variable to use query values, the application uses any values that a user specifies for the query to select cases to include in the report, but does not use those values as breakdown details. For example, the query is for generic name and generic name is a breakdown variable with Every Distinct Value specified for breakdown details. If the user specifies DrugA as the query value, the report includes only cases with DrugA, and it includes a column for each value of generic name for those cases.