SEQUEL views can be regrouped or drilled into to provide new insights

SEQUEL ViewPoint allows you to view the data in your databases in different ways. When you create a view by using a function that groups (summarizes) data, you automatically create views that can be “drilled into” to see the supporting detail. Views that include functions, such as SUM(), MIN(), MAX, COUNT(), or AVG() let you drill into the displayed results.

Note: This feature requires fields to be added to the Dynamic Drill Down Field list. This list is stored in a file (SEQUEL/VPTDYNFLTR) that you can maintain easily using ViewPoint Administrator, or a green screen command line with UPDATE, INSERT, or DFU.

Drilling down from the summary level to the detail is easy. When you right-click on a result, you can select from two options: Regroup or Show details.

Regroup
The Regroup option lets you sort the entire result set and re-summarize it by one of the many fields. You can run this process repeatedly without any changes to the view.

The Regroup Data window lists all fields from all files used in the view that are also defined in the Dynamic Drill Down Field List. If no fields from the starting view exist in the Dynamic Drill Down List, a dialog displays allowing you to list all fields for the view. Just place a check next to all the fields for which you want to regroup the data.

Right-click on BMXCARTON and choose to regroup the data.

If you choose to regroup using the state field (left) and press the OK button, a second window opens displaying the new results (right).

Show Detail
This option shows the supporting detail for the selected grouped record, allowing you to drill-into the data that created the summary information. Right-click on a specific line, select “show details,” and select the data you want to see from the detail of that line.

Again, you can run this process repeatedly without any changes to the view.

In this example, right-click on Illinois and choose “Show details” and name to display customer detail.

SEQUEL filters the original data set to display customers in Illinois.

Contributed by Carlo Panzarella, Technical Consultant

This entry was posted on Wednesday, April 16th, 2008 at 11:12 am and is filed under SEQUEL. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.