Setting 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, the application 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.         Click the Data Mining Runs tab.

The Data Mining Runs page appears.

2.         Select the row menu (Row menu) for a run, and then click View Jobs for Run.

The Jobs for Run page appears.

3.         Click Sources.

The Data Sources page appears.

4.         Select a table.

The selected table appears.

5.         Click Options.

The Table Viewing Options page appears.

6.         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.

A.        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.

B.        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. 

7.         In the Rows per page field, type the number of rows to display per page. (The default is 15.)

8.         To show the number of rows and current filter information above the table, check Show heading.

9.         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.

10.      To show the SQL WHERE clause that the application used to construct the displayed table, check Show SQL.

11.      If you want the table to include columns for which no values exist, check Show empty columns.

12.      From the Include columns list, check the columns to include in the table.

13.      Click Save.

The modified table appears.