Re: SQR / Hyperion SQR Production Reporting

From: Job Miller <>
Date: Sat, 16 Jul 2011 17:34:07 -0700 (PDT)
Message-ID: <>

A few clicks on OTN, and you can find almost anything.

From: David Roberts <>
Sent: Saturday, July 16, 2011 7:27 PM
Subject: Re: SQR / Hyperion SQR Production Reporting

I have to state that I am not a fan of SQR having seen it misused to produce incredibly simple, comprehensible but hugely inefficient reports.
On the plus side, i.e. in terms of answering your query in a useful manner, before its aquisition by Brio/Hyperion/Oracle, it was licenced to other companies as a built in report function.
Amongst these compaies, were Maximo (Maintenance management system.) and Peoplesoft.
It would be my expectation, that it would still be bundled with these products, and while I wouldn't expect that Oracle would still be promoting it or selling it as an individual product, they may still bundle it with Peoplesoft for backward compaability.
On Fri, Jul 15, 2011 at 9:29 PM, Peter Robson <> wrote:

Many (many) years ago I used a report writer product called SQR, which in those days was owned and marketed by IBM (I think). It was a really neat piece of kit, enabling one to integrate the non-procedural elements of SQL within a true procedural language. It was marketed as a report writer, but in fact that was selling it drastically short of its true abilities.
>I have been looking around for a scripting language for a certain task I want to run with Oracle, but nothing came to mind. SQL and PL/SQL won't hack it (sic!) on their own. Perl etc probably would, but for me that is a whole new learning process. Then I remembered SQR. A little research reveals that the product is now owned by Oracle Corporation! Given all the acquisitions Mr Ellison has been performing, perhaps I shouldn't have been surprised...
>Whatever, it is now known as Hyperion SQR Production Reporting.
>Can anyone advise how I can get hold of this product, without having to take the whole Hyperion suite on board? The obvious searches have not helped so far. Presumably as an Oracle product it must be available for trial download somewhere.
Received on Sat Jul 16 2011 - 19:34:07 CDT

Original text of this message