Create a query-based case series

You can create a query and include the cases found by the query in the case series.

To create or edit a query-based case series, use the Query Wizard, which guides you through the process of selecting variables, selecting values, and specifying query logic.

Note:

If you edit and re-execute the query portion of a query-based case series to which cases have been transferred or added manually, Oracle Empirica Signal drops those cases from the case series if they do not meet the query criteria.

1. In the left navigation pane, hover on the Data Analysis icon (), then click Case Series.
2. Click Create Using Query Wizard.
3. From the Configuration drop-down list, select a data configuration. You can click Browse to select from a list of data configurations.
4. Click Next to define the query conditions.
5. Click Select Variables.
6. Select variables from the left-hand list and move them to the Selected Variables list on the right.
7. From the Table drop-down list, select All Tables or a specific table.
8. In the Match field, enter a variable to find.
9. Click OK.
10. Build the query on the Define Query page by selecting the values to include.
11. Click Next.
12. Review the data source and query logic. To preview the query results, click Preview Cases. This option is available only if you specified values for all variables and your user preference Show case count by default on preview page is enabled.
13. Click Close, then Next.
14. Save the query by specifying a name for the query. The name does not need to be unique, although we recommend that you use a unique name.
15. In the Description field, leave the description or add a description of the query.
16. Choose one of the following:
    • To assign the case series to an existing project, click Add to existing project and select the project from the drop-down list. Only projects associated with objects that you created or that are published to you appear in the list.
    • To create a new project and assign the case series to it, click Add to a new project named and enter a project name.
17. Click OK.

    Oracle Empirica Signal submits the case series to the background processing job queue. For larger datasets, the Background Processing indicator appears next to your username at the top of the page.

    Note:

    The Background Processing indicator may not appear if you create a case series from a small data set that processes quickly.