Drill-Down

SEQUEL enhances data analysis with a number of different drill-down approaches that let you explore both System i data and the information contained in other applications or platforms.

Dynamic Drill-Down

SEQUEL’s dynamic drill-down capability lets you analyze your System i database in ways you never thought possible. Best of all, you can display your data in just a few minutes.

• Sets up quickly.

  In just minutes, even non-technical staff can design a SEQUEL view with drill-down capabilities. All you need is a single view—no predefined drill paths or definitions are necessary.

• Works directly with non-summarized transaction files.

  You don’t have to set up a “cube” or “datamart” to take advantage of powerful drill-down operations. SEQUEL can easily drill down into System i transaction databases, even the ones containing millions of records.

• Lets you "see" System i data like never before.

  Within minutes of installing SEQUEL, you can explore your System i database in ways you never thought possible.

For example, using just one SEQUEL view that takes less than a minute to set up, you can display company information at a regional-summary level…

(Click image to enlarge.)

…then drill-down to explore details by state within region…

(Click image to enlarge.)

…then drill into details for each customer wwihtin the state.

(Click image to enlarge.)

There’s no limit to the number of levels—you can drill down to the lowest level of detail available in the file used in your view.

Application Builder

SEQUEL’s Application Builder lets you create drill-down applications with pre-defined paths and results. You can define drill-down options to show data summarized at different levels or link to other applications or documents. Your drill paths can navigate downward, upward, or even “sideways” to analyze the information you need.