IBM® DB2® Web Query for i offers a set of modernized tools for a more robust, extensible and productive reporting solution than the popular Query for System i® (also known as Query/400) tool. 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 offer significant productivity and performance enhancements by leveraging the latest in DB2 for i query optimization technology.
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 Redpaper® publication provides a broad understanding of the new DB2 Web Query product. It entails a group of self-explanatory tutorials to help you get up to speed quickly. This redpaper is part of the complete redbook DB2 Web Query for i Implementation Guide - Version 2.1 - SG24-8063.
Table of contents
Chapter 1. Assignment #8: Building Documents/Dashboards
1.1 Documents and Dashboards
1.1.2 What is a Dashboard?
1.1.3 Developing KPIs
1.1.4 Business leader requests
1.1.5 Creating a dashboard document with InfoAssist.
1.1.6 Viewing business data on popular devices
1.2 Creating a document, adding an internally defined chart
1.2.1 Starting a new document
1.2.2 Adding a chart
1.2.3 Manipulating fields for the chart
1.2.4 Making layout changes to improve the look of the chart
1.3 Adding existing reports and charts to a document
1.3.1 Opening the existing document
1.3.2 Inserting an existing report
1.3.3 Inserting more charts or reports into an existing document
Chapter 2. Assigment #9: Exploring / comparing other dashboard options
2.1 Additional features of Web Query for documents
2.2 What is a coordinated document?
2.3 Creating documents with Form Control fields.
2.4 Self-service Dashboards using the BI Portal.
2.4.1 Favorites and Mobile Favorites.
2.4.2 Creating a Personal BI Portal
2.5 DB2 Web Query Developer Workbench
2.5.1 Why would you use developer workbench?
2.6 Configuring Developer Workbench
2.7 Setting Developer Workbench default options
2.8 Dashboard using HTML composer
2.8.1 Comparison between InfoAssist and HTML Composer
2.8.2 Compound parameterized report (HTML1_KPI)
2.8.3 Preparing the charts for the HTML composer
2.8.4 Adding controls to the HTML Composer canvas
2.8.5 Referencing external Procedures in the HTML composer
2.9 DB2 Web Query Spreadsheet client
2.9.1 Creating a Dashboard in Excel
These pages are Web versions of IBM Redbooks- and Redpapers-in-progress. They are published here for those who need the information now and may contain spelling, layout and grammatical errors.
This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. Your feedback is welcomed to improve the usefulness of the material to others.
IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a customer responsibility and depends upon the customer's ability to evaluate and integrate them into the customer's operational environment.