These analytic functions now include:
Ranking functions
Used to compute a record??™s rank with respect to other records. Functions
include RANK, DENSE_RANK, CUME_DIST, PERCENT_RANK, NTILE, and
ROW_NUMBER. Hypothetical ranking is supported.
Windowing aggregate functions
Used to compute cumulative and moving averages. Functions include SUM,
AVG, MIN, MAX, COUNT, VARIANCE, STDDEV, and FIRST_VALUE,
LAST_VALUE.
LAG/LEAD functions
Often used to compare values from similar time periods, such as the first quarter
of 2006 and the first quarter of 2007.
234 | Chapter 10: Oracle Data Warehousing and Business Intelligence
Reporting aggregate functions
Include SUM, AVG, MIN, MAX, COUNT, VARIANCE, STDDEV, and RATIO_
TO_REPORT.
Linear regression functions
Include REGR_COUNT, REGR_AVGX and REGR_AVGY, REGR_SLOPE,
REGR_INTERCEPT, REGR_R2, and other functions used in regression line fitting
for a set of numbers in pairs (e.g., having X and Y values).
Also supported in Oracle are pivoting operations, histograms (using WIDTH_
BUCKET), CASE expressions, filling gaps in data, and time-series calculations.
Pages:
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515