Warehouse Fact Table Editor, 288–89
Warehouse keys, 23–24
generating, 222–24
looking up, 262–63
operational system, 223
surrogate, 222–24
Warehouse Module Editor, 286, 287
Warehousing tools, 279–328
choosing, 279
Oracle Discoverer, 300–328
Oracle Warehouse Builder (OWB), 279–300
Web
data published on, 400
data warehousing and, 399–425
distributing reports to, 410–12
functions, 400–401
report building for, 421–25
See also Internet; Intranet
What-if analysis, 124–25, 430–31
WHEN clause, 267
WHERE clause, 111, 143, 174, 392
WIDTH_BUCKET() function, 115
Window aggregate functions, 109, 115–18
WITH clause, 129–30
benefits, 129
defined, 129
use example, 129–30
Workbook, 318, 320
Workload
defined, 197
filter, 197–98
hypothetical, 205
loading, 197, 200
user-defined, 200–201