RE: SQL Question

[<lgoodbar@xxxxxxxxxxxxxx>]

The question was on using rownumber over keywords to retrieve a
sequential number for an update query (so the rows have something line
N01, N02, N03). Unrelated to actual OLAP usage.

Speaking of OLAP, does anyone run Essbase (OLAP multidimensional
database by Hyperion/Oracle, formerly Arbor Software) on their "i"? I
recall that one time there was an "i" product.

Loyd Goodbar
Business Systems
BorgWarner Shared Services
662-473-5713
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave Odom
Sent: Wednesday, April 23, 2008 2:36 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: SQL Question

What was the question on the OLAP need?   I think I missed this.   The
only reason why I ask is while the i5 has the capability, I'm not sure
most folks know how to set up a dimensional data warehouse (dimension
and fact tables) to allow OLAP to be done on the i5.  Let me know if I
can help.
 
Dave Odom
Arizona