Book description
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 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.
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 161, as stand-alone tutorials for anyone who is developing their own queries.
Table of contents
- Front cover
- Notices
- Preface
- Part 1 Background, installation, and setup
- Chapter 1. Product overview and architecture
- Chapter 2. Installation and server operations
-
Chapter 3. Defining metadata
- 3.1 What metadata is
- 3.2 Creating metadata
- 3.3 Deleting metadata
- 3.4 Refreshing metadata when IBM i database object structure changes
- 3.5 Miscellaneous considerations about creating metadata
- 3.6 Joining database objects
- 3.7 Date decomposition
- 3.8 Understanding your data
- 3.9 Field formatting
- 3.10 New fields: Define versus Compute
- 3.11 Creating filters
- 3.12 Defining dimensions: InfoMini and OLAP
- 3.13 Segmenting and securing Metadata: DBA
- 3.14 Business views
- 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
- 6.1 How to open the Security Center
- 6.2 Registering user profiles to DB2 Web Query
- 6.3 How to designate a Web Query Administrator
- 6.4 Removing a user from a Web Query group
- 6.5 Adding a developer to a Top Level Folder
- 6.6 Giving run-only authority to an existing IBM i group profile
- 6.7 How to manage users and their attributes
- 6.8 Changing the owner of a report
- 6.9 Preparing steps for the tutorial
- 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
- 12.1 Simple filters: Revenue Simple Filter report
- 12.2 Advanced filters: Revenue Advanced Filter report
- 12.3 Filters in charts: Revenue trend graph with a variable date range
- 12.4 Filter in metadata: Europe Revenue and Profit report
- 12.5 InfoMini Slicers: InfoMini Revenue and Cost report
- 12.6 InfoMini Formats: InfoMini Revenue and Cost Format report
- 12.7 Publishing your folder
-
Chapter 13. Assignment #6: Detail/print reports
- 13.1 A graphical structure of the application
- 13.2 Creating the basic summary report with Info Assist (6a - Basic Summary Report)
- 13.3 Creating a summary report with a parameter (6b - Summary Report Product Category)
- 13.4 Creating a detail report with a parameter (6c - Detail Report Product Number)
- 13.5 Converting a report to a chart
- 13.6 Creating a chart (6d - Chart Good Profit)
- 13.7 Creating drill downs and putting it all together
- Chapter 14. Assignment #7: Implementing OLAP
- Chapter 15. Assignment #8: Building documents and dashboards
- Chapter 16. Assignment #9: Exploring and comparing other dashboard options
-
Chapter 17. Assignment #10: Scheduling and distribution of reports
- 17.1 Report Broker overview
- 17.2 The assignment
- 17.3 Configuring Report Broker
- 17.4 Scheduling a simple report and distributing by email
- 17.5 Scheduling a report with parameters and distributing it via email
- 17.6 Scheduling a report and distributing it by DB2 Web Query
- 17.7 Scheduling a report and distributing it by FTP
- 17.8 Scheduling a report and distributing by printer
- 17.9 RUNBRSCHED command
- 17.10 Report Broker Console
- Chapter 18. Assignment #11: Going mobile
- Chapter 19. Assignment #12: Stored procedures in action
-
Chapter 20. Assignment #13: Query/400 modernization
- 20.1 Query/400: a reliable reporting tool
- 20.2 DB2 Web Query versus Query/400: Function similarities
- 20.3 DB2 Web Query versus Query/400: Function differences
- 20.4 The assignment
- 20.5 Creating metadata over Query/400 objects
- 20.6 Using DB2 Web Query to edit a QRYDFN
- 20.7 Modernizing Query/400 definitions
- 20.8 The migration dilemma for Query/400 reporting
- 20.9 Modernizing your reporting
- 20.10 Replacing Query/400 objects with Active Reports
- 20.11 Additional parameter tips
- Chapter 21. Assignment #14: Creating JD Edwards reports
- Chapter 22. The Century Challenge BI solution: Postmortem
- 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
- Appendix D. Configuring Developer Workbench
- Back cover
Product information
- Title: IBM DB2 Web Query for i Version 2.1 Implementation Guide
- Author(s):
- Release date: January 2014
- Publisher(s): IBM Redbooks
- ISBN: None
You might also like
book
IBM DB2 Web Query for i: The Nuts and Bolts
Abstract Business Intelligence (BI) is a broad term that relates to applications that analyze data to …
book
SQL Procedures, Triggers, and Functions on IBM DB2 for i
Structured Query Language (SQL) procedures, triggers, and functions, which are also known as user-defined functions (UDFs), …
book
The Ins and Outs of XML and DB2 for i5/OS
XML represents a fundamental change in computing. It allows applications to move away from proprietary file …
book
External Procedures, Triggers, and User-Defined Functions on IBM DB2 for i
Procedures, triggers, and user-defined functions (UDFs) are the key database software features for developing robust and …