Hyperion SQR Production Reporting (OBIEE) Overview

 

Overview

The SQR Production Reporting module generates high volume, presentation-quality formatted reports with unparalleled performance—even when the data is taken from disparate sources. This reporting application delivers business context for key metrics by consolidating information from core business applications throughout the enterprise.

Product History

Since the mid-1980s, SQR Reporting has been part of numerous reporting suites with companies such as Sybase, MITI and Brio Software.  Prior to the Hyperion acquisition of Brio in 2003, the product was distributed under the name Brio Reports.  The product then became part of the Hyperion Performance Suite as Hyperion SQR, pre-System 9.  Hyperion SQR included SQR Activator, SQR Server, SQR Viewer, SQR Developer and SQR iServer.  As part of System 9, these modules were integrated and packaged as Hyperion Production Reporting.  With release 9.3, the product was changed to its current name, Hyperion SQR Production Reporting.  The product is currently part of Oracle’s BI Enterprise Edition Plus (OBIEE+) suite. 

Strengths / Benefits

• User Friendly GUI - delivers its comprehensive enterprise reporting capabilities through a graphical report creation environment and a powerful 4GL reporting language (called SQR) for advanced reporting and data processing.
• Multiple Data Sources - Including IBM DB/2, SAP R/3, SAP NetWeaver BI, and SQL Server.
• Flexible and Scalable - Report designers can take advantage of SQR Production Reporting's comprehensive report lifecycle management, flexible formatting, layout, and distribution options. Additionally, SQR Production Reporting provides proven, massive scalability through report bursting, and reduced processing time from single-pass production of reporting jobs.
• Common Infrastructure - Shares common administration, user management, and installation and configuration support with other Hyperion BI modules of Oracle Business Intelligence Suite Enterprise Edition Plus.

Resources

• Oracle Hyperion Documentation
• SQR Production Reporting Datasheet

---