Create a query-based report output

You can run a query-based report definition and save its output in a single step.

  1. In the left navigation pane, hover on the Data Analysis icon ( Data Analysis icon ), then click Interactive Reports.
  2. Click the Row Action menu ( Row Action menu icon ) for the report definition, and then click Create Output.
  3. From the configuration drop-down list, select a configuration.

    The report runs against source data for the selected data configuration. When you save the report output, the application verifies that the selected data configuration has a Drug type variable with a subtype of Generic, Trade, or Ingredient.

  4. Click Next.
  5. On the Run Query page, fill in the fields, and click Next.
  6. Fill in the fields on the Create Output page:
    • Name for Output—Name for the saved output. The name does not need to be unique, although Oracle recommends that you provide a unique and meaningful name.
    • Output Description—Description of the saved output that differentiates the report output from entries on the Report Outputs page.
    • Output Category—Type of report output: Ad Hoc or Standard. The application uses the category for organizing reports and the category is not related to report availability. You can include a column showing report categories on the Report Outputs pages.
  7. Select an option for assigning the report output to a project:
    • Add to existing project—Assign the report output to an existing project by selecting from a list of projects associated with objects that you created or that are published to you.
    • Add to a new project named—Create a new project and assign the report output to it.
  8. Click Save.

Oracle Empirica Signal submits the report output to your background processing job queue, and the Background Processing indicator appears next to the Preferences link.