|
 | Modernize Query for IBM® iSeries® (Query/400) reports with browser-based tools |
| Hide complexity of accessing data from end users through metadata layer and parameterized reports |
| Improve performance of queries by leveraging advanced IBM DB2® for i5/OS® query optimization features |
| Reduce IT support efforts with single server-based installation and maintenance |
|
|
 |
i want everything to just work.
i want control.
i want an i
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 iSeries (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.
DB2 Web Query provides the ability to query or build reports against data stored in DB2 for i databases through browser-based user interface technologies. Build new reports with ease through the Ajax-based WYSIWYG Power Painter component, or leverage the wizard-like Report and Graph Assistant components.
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.
Add the OLAP (On-Line Analytical Processing) feature to interact with the data through slicing and dicing and drill-down capabilities. For the end user on the go, choose the Active Reports feature to allow reporting without having to be connected to the server. Build simple dashboards or compound reports with the optional DB2 Web Query Developer Workbench. Use the Developer Workbench to hide the complexities of the database (for example, join logic) from end users through metadata.
|
