Add a drilldown map table

  ShowHide

1.         In the left navigation pane, click the Settings icon ().

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

3.         Click the Row Action menu () for a configuration, and then click Edit.

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

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

6.         Click Create New Table.

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

8.         Click Create Table.

The new table appears as the selected drilldown table. The first column of the drilldown map table shows the information type.

9.         Edit the drilldown map table as necessary.

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.

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

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

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

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

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

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

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

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

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

I.           Click Save.

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

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.