Qport® SmartView users enjoy the ease of use and flexibility of a Microsoft® Excel-style interface while using the scalability and power of IBM® i to support analytics. Instead of maintaining massive Excel workbooks with complex formulas and pivot tables, users can quickly interact with multidimensional displays of read-only data.

Due to its design, SmartView  can provide answers in seconds—whether you want to see sales by division and territory; product orders by quarter, month and week; shipments by distribution center; aged payables in 30, 60, and 90-day buckets; or any other type of analytical report.

You can format, pivot, filter, chart, drill into, and analyze your data in virtually unlimited ways. Your matrix can include calculated values like margins, averages, totals, percentages of totals, and other information at each drill-down level.

Integrated Data Visualization

SmartView allows you to design and customize charts, save charts within your matrix, and design chart templates you can share with others. SmartView charts are in HTML5 format and can be exported in a wide range of popular graphic formats to use in presentations or elsewhere.

You can also select fonts, type sizes, type styles and colors, background colors, titles, numeral formats, critical value highlighting rules, and other elements to make your data easy to see and understand.

Fast Access to Real-Time Operational Data

You can refresh a SmartView matrix with new data in one click. If you like, you can password protect your matrix so other SmartView users can analyze the data but not refresh the matrix or change your layout.

SmartView includes a built-in zip utility so you can zip and share matrices with other SmartView users via the Web or email. Even traveling or off-network users can open, study, and work with the data you want them to see.

Complete Integration with NGS-IQ™

SmartView is an integrated module of the NGS-IQ query, reporting, and analytics system. This integration means you benefit from the comprehensive database extraction, formatting, calculation, and aggregation features of NGS-IQ when transferring data to SmartView. Also, you can provide your managers with easy access to your data without compromising security or performance.

What is NGS-IQ?

NGS-IQ is a comprehensive query, reporting, and analytics solution built for IBM i. It includes both IBM i and Windows-based data extraction and reporting tools that provide you with advanced functionality and presentation features.

NGS-IQ users can create and run queries on IBM i from Windows, Web pages, portals, Web applications, Web-enabled smartphones, and 5250 “green screen” interfaces.

NGS-IQ’s Qport Access module on the Windows desktop is the bridge that delivers data to SmartView. Qport Access provides run-time access to NGS-IQ queries and supports the ad-hoc entry of selection criteria, calculation formulas, and output target, including Excel, Word, Microsoft Access, the Windows display, and IBM i or ASCII printers.

All NGS-IQ queries operate in accordance with your IBM i security settings. You may also develop database and report authority specifically for your NGS-IQ users with the IQ SeQure™ module. less

NGS-IQ and IQ SeQure are trademarks of New Generation Software, Inc. Qport is a registered trademark of New Generation Software, Inc. All other trademarks are the property of their respective owners.