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. Key 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 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.
This IBM Redbooks® 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. Overall, this book is designed for IT users. You can use Part 2, “Tutorials for DB2 Web Query” on page 153, as stand-alone tutorials for anyone who is developing their own queries.
Table of contents
Part 1. Background, installation, and setup
Chapter 1. Product overview and architecture
Chapter 2. Installation and server operations
Chapter 3. Defining metadata
Chapter 4. Security Center
Part 2. Tutorials for DB2 Web Query
Chapter 5. Getting started with the tutorials
Chapter 6. Security Center - Setting up users
Chapter 7. Creating and editing metadata - Century Database
Chapter 8. Assignment #1: Summary Reports
Chapter 9. Assignment # 2: Implementing Various Date Functions in Reports
Chapter 10. Assignment # 3: Implementing Other Report Features and Formats
Chapter 11. Assignment # 4: Charting
Chapter 12. Assignment #5: Adding filters to reports and charts
Chapter 13. Assignment #6 : Detail/print reports
Chapter 14. Assignment #7: Implementing OLAP
Chapter 15. Assignment # 8: Building Documents/Dashboards
Chapter 16. Assignment #9: Exploring/comparing other dashboard options
Chapter 17. Assignment 10: Creating JDE Edwards reports
Chapter 18. Assignment #11: Scheduling and Distribution of reports
Chapter 19. Assignment #12: Going mobile
Chapter 20. Assignment #14: Stored procedures in action
Chapter 21. Assignment #15: Query/400 Modernization
Part 3. Miscellaneous topics
Chapter 23. Performance Case study
Chapter 24. Migration Considerations
Chapter 25. IBM i Business Intelligence Solution
Chapter 26. Adapter for Microsoft SQL Server
Part 4. Appendixes
Appendix A. Date and time functionality
Appendix B. DB2 Web Query System Variables
Appendix C. Change management considerations
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.