Specifying a drill-down map table

In this section ShowHide

During many activities, such as viewing data mining results, users can click case ID links to drill down to a list of cases (first-level drilldown) and can then drill down further to view case details (second-level drilldown). The type of data presented during drilldown is from the source database tables, and is determined by the drilldown map table associated with the data configuration.

Drilldown information comes from the source data. Users do not see values for a variable that includes a data transformation defined in the configuration, or any values that are missing from the source data.

Note: Drilling down to view case details is possible only if the appropriate site option has been set and the user has the appropriate permission.

Selecting a drilldown map table

1.         Click Settings.

The Settings page appears.

2.         In the Configure System section, click Manage Configurations.

The Manage Configurations page appears.

3.         Click Add Configuration.

The Add/Import Configuration page appears.

or

A.        On the Manage Configurations page, click the row menu () for a configuration, and then click Edit.

The Modify Configuration page appears.

B.        In the right-most column of the configuration, click Edit.

The Edit Configuration Details page appears.

4.         Next to the Drilldown Map field, click Select/Edit Table.

The Select/Edit Drilldown Table dialog box appears.

5.         From the Select Drilldown table drop-down list, select a drilldown map table and click OK. Available drilldown map tables are those in the Oracle account to which you are connected.

Creating a drilldown map table

1.         In the Select/Edit Drilldown Table dialog box, click Create New Table.

2.         In the Enter name of new drilldown table field, type a name for the new table. Table names cannot include:

• Spaces
• ?, \, or "

It is recommended that you use a name that distinguishes the table from other drilldown map tables and indicates the table’s purpose, such as DRILLDOWN_MAP.

3.         Click Create Table.

The new table appears as the selected drilldown table.

The first column of the drilldown map table shows the information type.

4.         Edit the drilldown map table as described below.

Editing a drilldown map table

Note: The same drilldown map table may be used by more than one data configuration in the Oracle account. Before editing a drilldown map table, make sure you want the changes to apply to all data configurations that refer to the drilldown map table.

1.         In the Select/Edit Drilldown Table dialog box, from the Select Drilldown table drop-down list, select the drilldown table.

2.         Select the Type you want to edit and click Edit. (If you want to clear values for the type, click Clear.)

Another dialog box appears for you to specify variables for the type.

3.         In the Table field, click Select to open the Select Table and Column dialog box and select an available table and column for the drilldown table to reference.

The application populates the Table field and Report ID Column field with your selection. The column should be compatible with the column for case IDs in the source data used in data mining.

4.         In the Section Title field, type a label for the section of the drilldown map table.

This label appears on the Case Details page as the section heading.

5.         In the Worksheet label field, type a label for the application to apply to the table worksheet.

This label appears on the worksheet tabs when Case Details are downloaded to Excel.

6.         In the Display Columns section, select and label each column to include.

A.        From the first Column drop-down list, select a variable.

B.        In the corresponding Label column, type a label (column heading) to apply to the variable in the drilldown table.

In the drilldown information, variables appear in the order in which you specify them.

7.         If you want the drilldown information to show only distinct values for the variables, check Distinct.

8.         Click Save.

9.         When you have finished specifying all types of information that you need, click OK.

The Select/Edit Drilldown Table dialog box appears with the Table, Report ID Field, and Display Columns columns filled in.

Copying a drilldown map table

1.         In the Select/Edit Drilldown Table dialog box, from the Select Drilldown table drop-down list, select the drilldown table.

2.         Click Copy Table.

3.         In the Enter name of new drilldown table field, type a name for the new table. It is recommended that you use a name that distinguishes the table from other drilldown map tables and indicates the table’s purpose.

4.         Click Create Table.

5.         Edit the drilldown map table as needed.

Drilldown information types

The following table lists the types of information that you can include in the drilldown map table and the corresponding label in the drilldown display. The LIST type determines contents of the Cases page (first-level drilldown), and its first variable must represent the case ID. All other types determine contents of the Case Details page (second-level drilldown). Typically, the CASE, DRUG, and EVENT types, at a minimum, are included on the Case Details page. The following table shows each type and the corresponding name of the section on the Case Details page; types are listed in the order in which they appear on the Case Details page.