IBM DB2 Web Query for i Tutorials

An IBM Redbooks publication

Published 13 April 2017

Authors: Yu Yu Wang, Yu Zhe Zhi, Lin Lin Su, Doug Mack, Simona Pacchiarini, Jim Bainbridge, Hernando Bedoya, Rob Bestgen, Michael Cain, Kathryn Steinbrink

Abstract

Business Intelligence (BI) is a broad term relating to applications designed to analyze data for purposes of understanding and acting on the key metrics that drive profitability in an enterprise. Essential to analyzing that data is providing fast, easy access to it while delivering it in formats or tools that best fit the needs of the end user.

At the core of any business intelligence solution are end user query and reporting tools that provide intuitive access to data supporting a spectrum of end users, from executives to "power users," from spreadsheet aficionados to the external internet consumer.

IBM® DB2® Web Query for i provides a set of modernized tools for a more robust, extensible and productive reporting solution than the popular Query for IBM System i® tool (also known as Query/400). IBM DB2 Web Query for i preserves investments in the reports developed with Query/400 by offering a choice of importing definitions into the new technology or continuing to run existing Query/400 reports as is. But it also offers significant productivity and performance enhancements by leveraging the latest in DB2 for i query optimization technology.

The DB2 Web Query for i product is a Web-based query and report writing product that offers enhanced capabilities over the IBM Query for iSeries product (also commonly known as Query/400). IBM DB2 Web Query for i includes Query for iSeries technology to assist customers in their transition to DB2 Web Query. It offers a more modernized, Java-based solution for a more robust, extensible, and productive reporting solution.

DB2 Web Query provides the ability to query or build reports against data stored in DB2 for i (or Microsoft SQL Server) databases through browser-based user interface technologies:


  • Build new reports with ease through the web based, ribbon-like Info Assist tool that leverages a common look and feel that can extend the number of personnel that can generate their own reports.
  • Simplify the management of reports by significantly reducing the number of report definitions required through the use of parameter driven reports.
  • Deliver data to end users in many different formats, including directly into spreadsheets, or in boardroom-quality PDF format, or viewed from the browser in HTML.
  • Leverage advanced reporting functions such as matrix reporting, ranking, color coding, drill-down and font customization to enhance the visualization of DB2 data.


DB2 Web Query offers features to import Query/400 definitions and enhance their look and functionality. It enables you to add OLAP-like slicing and dicing to the reports or to view reports in disconnected mode for users on the go.

This IBM Redbooks® publication provides a broad understanding of what can be done with the DB2 Web Query product. It entails a group of self-explanatory tutorials to help you get up to speed quickly. Overall, this book is designed for IT users. This publication is a companion of another IBM Redbooks publication, DB2 Web Query The Nuts and Bolts, SG24-8379.

Table of contents

Chapter 1. Getting started with the tutorials
Chapter 2. Security Center: Setting up users
Chapter 3. Creating and editing metadata: Century database
Chapter 4. Assignment #1: Summary reports
Chapter 5. Assignment #2: Implementing various date functions in reports
Chapter 6. Assignment #3: Implementing other report features and formats
Chapter 7. Assignment #4: Charting
Chapter 8. Assignment #5: Adding filters to reports and charts
Chapter 9. Assignment #6: Detail/print reports
Chapter 10. Assignment #7: Implementing OLAP
Chapter 11. Assignment #8: Building documents and dashboards
Chapter 12. Assignment #9: Exploring and comparing other dashboard options
Chapter 13. Assignment #15: Creating JD Edwards reports
Chapter 14. Assignment #18: Scheduling and distribution of reports
Chapter 15. Assignment #11: Going mobile
Chapter 16. Assignment #12: Stored procedures in action
Chapter 17. Assignment #13: Query/400 modernization
Chapter 18. The Century Challenge BI solution: Postmortem

Follow IBM Redbooks

Follow IBM Redbooks