Set viewing options for a data source table

Viewing options allow you to sort rows as needed and choose which columns to include in a data source table. The options apply to the specific table during your current session. When you exit and log back in, Oracle Empirica Signal resets the options to the default settings.

While setting options, click Clear to reset the options to the default settings (except for which columns to include).

1. In the left navigation pane, hover on the Data Analysis icon (), then click Data Mining Runs.
2. From the Project drop-down list, select a project, or select -- to include all projects.
3. From the Configuration drop-down list, select a data configuration, or select -- to include all configurations.
4. Select the Row Action menu icon () for a run, and then click View Jobs for Run.
5. In the upper-right corner, click Sources.
6. Click the name of the data source table that you want to view.
7. Click Options.
8. Specify up to three columns by which to sort the table. You can sort on columns, regardless of whether or not the columns appear in the displayed table. You can also sort by clicking the column headers in the table itself.
   1. From the Sort By drop-down list, select a field to sort by. To sort data in descending order, click the Descending check box. Otherwise, results appear in ascending order.
   2. Within the primary sort, specify up to two additional sort orders by selecting them from the Then By drop-down lists. To sort data in descending order, click the Descending check box. Otherwise, results appear in ascending order.
9. In the Rows per page field, type the number of rows to display per page. (The default is 15.)
10. To show the number of rows and current filter information above the table, check Show heading.
11. To show a description of the source database, check Show notes. The description comes from the source description table for the configuration used by the run.
12. To show the SQL WHERE clause that the application used to construct the displayed table, check Show SQL.
13. If you want the table to include columns for which no values exist, check Show empty columns.
14. From the Include columns list, check the columns to include in the table.
15. Click Save.