Re: analytics reference
Date: Tue, 12 Aug 2014 12:54:47 -0500 (CDT)
Message-ID: <a9e01a117b7de213c80b471b2320a0b7.squirrel_at_society.servebeer.com>
Chris replies:
> I had to use a combination of resources together. I the Oracle Data
> Warehousing documentation (believe it or not) helped me a ton - reading the
> documentation (in order of each function) and then looking at examples from
> different blogs to see the query in action (and various forms it could
> take).
...
> P.S. When you finally write a MODEL statement and understand it and can
> manipulate it, it's AWESOME. (I've only done it a handful of times and
> would have to refresh my own use of it because I never see it in use by
> anyone besides me)
I was messing with the MODEL statement myself a few years back to plot the linear regression of DB storage growth (yes, Excel graphs that way easier -- the exercise was academic!). While no help with MODEL itself, these DB2 resources were great easy-to-digest additions to the docs Chris mentioned:
http://www.redbooks.ibm.com/abstracts/sg246546.html
http://www.almaden.ibm.com/cs/people/peterh/b15.pdf
My $.02,
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 12 2014 - 19:54:47 CEST