Values Graph Drill Down Functions

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

brand
Software
prodname
Teradata Warehouse Miner
vrm_release
5.4.4
category
User Guide
featnum
B035-2300-077K

Drill down into one or more graph values to see source data rows. Each value selected will be entered into an editable drill down list automatically (a drill down window pops up as values are clicked). All values in the list will be used as drill down criteria, resulting in a drill down data table containing rows belonging to all of the values selected.

First, select graph values that target the source data of interest (such as all rows that contain positive values).

There are two ways to select graph values for drill down:
  1. In the Zoom View, click on one or more bars or circle graph segments to add values to the drill down list.
  2. Or, send values to the drill down list by selecting rows in the data selector, right-clicking on the rows and clicking on the ‘Drill Down’ pop-up menu item. All non-null and non-zero count values will be added to the drill down list for each column selected.

The drill down list can be edited after graph selections are added, and saved for future reference.

Second, select the ‘drill down’ tab on the Drill Down window to query the source data table. Filtered rows (rows that fit the drill down criteria) will be returned and displayed in the drill down table.

In the header of the drill down display are options to “show graph data only” or “include related columns”. The tabular icon to the right of these two options in the header can be used to select up to 20 columns for display with the second option. By default, the first 20 columns when sorted alphabetically are displayed with the second option. The “sql” to the left of the tabular icon can be used to copy the SQL Where clause for the drill down query to the Clipboard for pasting into another text area or application.

Values Drill Down List

Additional drill down features:
  • Save each list before creating a new one if it needs to be used again. After saving, a small icon appears next to the drill down icon in the upper right corner of the graph page.
  • Clicking on the thumbnail reloads the saved list, enabling repeated reviews of the source data. In addition, the saved list can be copied, edited by deletions or additions, and then replaced over the old list or saved as new. Clicking on the drill down icon reveals a list of default descriptive labels for the saved drill downs, which can be changed to something the user finds more meaningful.
  • Saved drill down lists can be deleted by right-clicking on thumbnail icons, or from the drill down label list.
The following right-click menu options are available from the display of drill down data rows after drill down is performed. They can be used to copy data to Microsoft Excel or to the Clipboard. When copying data to the Clipboard, columns are delineated by tab characters.
  • Export to Excel — All Rows
  • Export to Excel — Selected Rows
  • Copy (to Clipboard) — All Rows
  • Copy (to Clipboard) — Selected Rows
Drill down cannot retrieve source rows for a column that is renamed with an alias. Drill down will also not work properly when the table being analyzed is a volatile table created by a referenced analysis that doesn't create an output table or view.
Note also that drill down with the histogram crosstab option selected will not work properly if either subject column name is greater than 24 characters in length, in which case the workaround is to create a view to analyze.