SQR

SQR (Hyperion SQR Production Reporting, Part of OBIEE) is a programming language designed for generating reports from database management systems. The name is an acronym of Structured Query Reporter, which suggests its relationship to SQL (Structured Query Language). Any SQL statement can be embedded in an SQR program.

History

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. Sybase purchased SQ Software in the early 1990s. To avoid competing directly with Oracle Corporation, Sybase had a marketing and development agreement with MITI for the Oracle database 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 the compiler 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.

SQR-Related Products

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 powerful database and printing functions. It can embed any SQL statement almost anywhere in a program. There is a version of SQR that can use multidimensional databases like Essbase. It can combine database reads with print instructions. It flexibly formats data breaks and page breaks. It prints variable fonts, sizes, and colors. It has a graph generation command that offers dozens of parameters for adjusting content and appearance.

Syntax

SQR has four scalar data types. The first three are numeric (variables begin with “#”), character string (variables begin with “$”), and date (variables begin with “$”, same as with character string variables.). Date variables must be declared, to be distinguished from character string variables. There is the option to declare numeric variables to specify them more precisely (integer, floating point, etc.). The last data type is a database column (variables begin with “&”). The values of database columns are set only by a SQL “select” statement; no other command can change their values.

SQR has arrays like those of the C programming language or COBOL. An array has one or more fields, each field either a numeric, string, or date variable. Each field may have multiple occurrences, giving SQR the equivalent of two-dimensional arrays. SQR has special commands that manipulate multiple items within a single array. There are also many commands that cannot use an array element in place of a scalar variable.

SQR has four control structures. The first three are if-else-end, while-end, and evaluate (like case or switch). The fourth is the embedded SQL “select” statement, which allows SQR statements to be executed for each row of data in a loop.

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.

External links

SQR release dates are published under the designation "Hyperion BI+" in the Oracle Lifetime Support for Middleware document