RE: Agregation function in SQL with CUBE?

[<lgoodbar@xxxxxxxxxxxxxx>]

Sorry, have not used it. We use Hyperion (now Oracle) Essbase for OLAP
needs, but learned about it from others during training.

Loyd Goodbar
Senior programmer/analyst
BorgWarner
TS Water Valley
662-473-5713

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Colorado
Sent: Thursday, February 07, 2008 12:03
To: Midrange Systems Technical Discussion
Subject: RE: Agregation function in SQL with CUBE?

Thank you, Loyd!

I thought nobody was to answer my question. Have you used this software?

 -----Original Message-----
From: 	midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]  On Behalf Of
lgoodbar@xxxxxxxxxxxxxx
Sent:	Thursday, February 07, 2008 12:24 PM
To:	midrange-l@xxxxxxxxxxxx
Subject:	RE: Agregation function in SQL with CUBE?

http://www.jedox.com/en/enterprise-spreadsheet-server/excel-olap-server/
palo-server.html

Free / donateware. Not sure on Crystal capability, but Crystal can read
excel spreadsheets.

Loyd Goodbar
Senior programmer/analyst
BorgWarner
TS Water Valley
662-473-5713
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Colorado
Sent: Monday, February 04, 2008 09:56
To: Midrange Systems Technical Discussion
Subject: RE: Agregation function in SQL with CUBE?

By the way, is anybody aware of a cheap (free if possible :) ) way to
generate OLAP cubes that can be used in Crystal Reports or other
reporting tools?

 -----Original Message-----
From: 	midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]  On Behalf Of CRPence
Sent:	Thursday, January 31, 2008 3:33 AM
To:	midrange-l@xxxxxxxxxxxx
Subject:	Re: Agregation function in SQL with CUBE?

   Not on an AS/400, but the DB2 for i5/OS SQL on v6r1 documents both 
keywords in the SQL Reference for the /group-by-clause/ under the 
/super-groups/ heading:
http://publib.boulder.ibm.com/infocenter/systems/scope/i5os/topic/db2/rb
afzgroupbyclause.htm?tocNode=int_227561

Regards, Chuck