Re: Some OLAP function perhaps?

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Rob,

Unfortunately, the system I work for is currently in the Dark Ages, but I
think that you need to use the SQL RANK() function. Check this URL:

http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf

HTH,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Mon, Sep 20, 2010 at 10:08 AM, <rob@xxxxxxxxx> wrote:

> I want to generate results like the following from a table with those
> columns, however, the summary row does not exist.  And, of the detail, I
> only want the 10 largest rows per library.
>
> Library  Object  Size
> BIGLIB           456789
> BIGLIB   BIGOBJ  200000
> BIGLIB   MEDOBJ  100000
> BIGLIB   SMLOBJ   50000
> ...
> MEDLIB           322457
> MEDLIB   BIGOBJ  150492
> MEDLIB   MEDOBJ   54329
> MEDLIB   SMLOBJ   12222
> ...
> SMLLIB           105298
> SMLLIB   BIGOBJ  102201
> SMLLIB   MEDOBJ      49
> SMLLIB   SMLOBJ       2
> ...
>
>
> Rob Berendt
> --
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>          Garrett, IN 46738
> Ship to:  Dock 108
>          6928N 400E
>          Kendallville, IN 46755
> http://www.dekko.com
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.