Re: SQR / Hyperion SQR Production Reporting
Date: Sun, 17 Jul 2011 00:27:07 +0100
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 <peter.robson_at_gmail.com>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.