SQR
This article needs additional citations for verification. (January 2019) |
SQR (Hyperion SQR Production Reporting, Part of OBIEE) is a programming language designed for generating reports from database management systems. The name is an abbreviation of Structured Query Reporter, which suggests its relationship to SQL (Structured Query Language). Any SQL statement can be embedded in an SQR program.
History
In the early 80's SQR was a 'free' add-on to
SQ Software created SQR in the mid 1980s. It had a marketing agreement with D & N Systems, which changed its name to SQL Solutions and was later acquired by Sybase Inc in the early 1990s. To avoid competing directly with Oracle Corporation, Sybase had a marketing and development agreement with MITI for the Oracle database compatible versions of SQR. MITI acquired the full rights to SQR in the mid-1990s. MITI changed its name to SQRiBE Technologies in 1997. Brio Technology acquired SQRiBE in August, 1999. Brio Technology later changed its name to Brio Software. Brio licensed its source code to PeopleSoft Inc. sometime around 2000. Hyperion Solutions Corporation acquired Brio Software in October, 2003. Oracle Corporation acquired PeopleSoft in December, 2004. In March 2007, Oracle Corporation acquired Hyperion Solutions.
- Oracle: Hyperion SQR Production Reporting - System 9 (Release 9.3.1, 2008);
- Oracle: Hyperion SQR Production Reporting - System 11 (Release 11.1.2, 2010);
- Oracle: PeopleSoft Enterprise Tools & Technology (PeopleTools, Release 8.52, 2011)
General components
- SQR Server
- SQR Viewer
- SQR Print
- SQR Execute
- SQR Workbench for Windows; SQR Developer
Features
SQR is notable for its
Syntax
SQR has four scalar
SQR has an
SQR has four
SQR has commands to open, read, write, append, and close computer files. File input and output is sequential and record-oriented only; random access is not supported.
See also
- Oracle Reports
- Actuate Reports
- Crystal Reports
Further reading
- SQR release dates are published under the designation "Hyperion BI+" in the Oracle Lifetime Support for Middleware document