Index

A B C D E F G H I J L M N O P R S T V W X

Numerics

3NF (third normal form), 2.2.1, 2.3.1

A

Add-Ins

for OLAP, 2.6.3

for predictive analytics, 2.6.4

addresses

cleansing, 2.1.2

aggregation

OLAP and relational, 2.4.3.2

Analytic Workspace Manager, 1.1.4.1, 2.3.3, 2.4.2, 3.2, 3.2.2

analytic workspaces, 2.3.3, 2.4.2, 3.2.2

anomaly detection data mining function, 2.5

application development tools, 1.1.4.4, 2.7

association model data mining function, 2.5

attribute importance data mining function, 1.2.2.4, 2.5

attributes

OLAP, 3.2.2.1

relational, 2.3.1

automatic summary management, 2.4.3.2

B

BI Beans

see OracleBI Beans

bursting, 1.3.6

business areas, 3.3.2.1

business intelligence

defined, 1.1

steps for implementing, 3.1.1

C

calculations

OLAP and relational, 2.4.3.3

classification data mining function, 2.5

cleansing names and addresses, 2.1.2

clustering data mining function, 2.5

conditional formatting, 1.2.1.2

cubes, 2.3.3, 3.2.2.1

D

dashboards, 1.3.1, 2.8.1

data

cleansing, 2.1.2

consolidating, 2.1

ETL, 2.1.2

filtering, 1.2.2.1

mapping source to target, 2.1.2, 2.1.2

models for BI, 2.2

operational, 2.1.1.1

pivoting, 1.2.2.3

processing mappings, 2.1.2

sources, 2.1.1

transactional, 2.1.1.1

transformation, 2.1.2

data marts, 2.3.2

data mining

data structure for, 2.3.4

functions, 2.5

in Excel, 2.6.4

data structures, 2.3

data warehouses

and business intelligence, 1.1.2

building, 2.1

defined, 1.1.2

data-driven formatting, 1.2.1.2

DB2 data, 2.1.1.1

development tools, 2.7

dimensional data model, 2.2.2

dimensions, 3.2.2.1

defined, 2.2.2.2

Discoverer

see OracleBI Discoverer

distributing reports, 1.3.6

drilling, 2.4.3.1

example, 1.2.2.2

E

e-mail

ETL notifications, 2.1.2

reports, 1.3.6, 2.8.2

ETL (extraction, transformation, and loading), 2.1.2

EUL (End User Layer), 2.4.1, 3.3.2.1

Excel, 1.3.3

data mining in, 1.3.3.2, 2.6.4

exporting to, 1.3.3.1

OLAP data in, 1.3.3.2, 2.6.3

exception data, 1.2.2.1

external data, 2.1.1.2

F

facts, 2.2.2.1

feature extraction data mining function, 2.5

financial statements, 2.6.1

forecasting, 1.2.3.2

form letters, 2.6.1

formatting

conditional, 1.2.1.2

report components, 1.2.5

stoplight, 1.2.1.2

FTP, 2.1.2

G

gauges

example, 1.2.1.1

portlet for, 2.8.1

graphs

drilling, 1.2.2.2

examples, 1.2.1.3

H

hierarchies

defined, 2.2.2.3

OLAP, 3.2.2.1

OLAP and relational, 2.4.3.1

I

Informix data, 2.1.1.1

interactive reports, 1.2.2.3, 1.3.2, 2.8.2

invoices, 2.6.1

J

Java beans, 2.7

JSPs (Java Server Pages), 2.7

L

layout

changing, 1.2.2.3

levels, 2.2.2.4, 3.2.2.1

M

mainframe data, 2.1.1.1

Mapping Editor in OracleBI Warehouse Builder, 2.1.2

mapping source data, 2.1.2

market basket analysis, 1.2.4.3, 2.5

measures, 2.2.2.1

metadata

differences between OLAP and relational, 2.4.3

OLAP, 2.4.2

relational, 2.4.1

models for forecasting, 1.2.3.2

moving averages, 1.2.3.1

N

names

cleansing, 2.1.2

O

ODBC data, 2.1.1.1

OLAP (online analytical processing), 1.1.2

attributes, 3.2.2.1

cubes, 3.2.2.1

metadata, 2.4.2

OLAP Catalog, 2.4.2

OLTP (online transaction processing), 2.2.1

Oracle Application Server, 2.8.1

Oracle Application Server Reports Services, 1.1.4.3

Oracle Business Intelligence

components, 1.1.4

packaging, A.1

Oracle Business Intelligence Tools

packaging, A.2

Oracle Data Miner, 1.1.4.2, 2.5

Oracle Data Mining, 2.5

data mining functions, 2.5

in Excel, 2.6.4

Oracle Database, 2.1.1.1

Oracle Reports, 1.1.4.2

described, 2.6.1

output options, 2.8.3

Oracle Spreadsheet Add-In for Predictive Analytics, 1.1.4.2, 1.3.3.2, 2.6.4

Oracle Transparent Gateways, 2.1.1.1

OracleAS Portal, 1.3.1, 2.8.1

OracleBI Beans, 1.1.4.4, 2.7

OracleBI Discoverer Administrator, 1.1.4.1, 2.4.1

OracleBI Discoverer example, 3.3

OracleBI Discoverer Plus, 1.1.4.2, 2.6.2

OracleBI Discoverer Portlet Provider, 1.1.4.3, 2.8.1

OracleBI Discoverer Viewer, 1.1.4.3, 1.3.2

described, 2.8.2

OracleBI Spreadsheet Add-In, 1.1.4.2, 1.1.4.2, 1.3.3.2, 2.6.3

OracleBI Warehouse Builder, 1.1.4.1, 2.1

Mapping Editor, 2.1.2

P

performance, 2.4.3.1, 2.4.3.3, 2.4.3.3

aggregation, 2.4.3.2

pluggable data sources in Oracle Reports, 2.6.1

Portlet Provider

see OracleBI Discoverer Portlet Provider

portlets, 1.1.4.3

predictive analysis, 1.2.4.2, 1.2.4.2

printing reports, 1.3.4

process flows in OracleBI Warehouse Builder, 2.1.2

R

ranking data, 1.2.1.4

regression data mining function, 2.5

reports, 1.2.4.2

available formats, 1.2.5

bursting, 1.3.6

conditional formatting, 1.2.1.2

dashboards, 1.3.1, 2.8.1

distributing, 1.3.6

drilling, 1.2.2.2, 1.2.2.2

e-mailing, 1.3.6, 2.8.2, 2.8.3

filtering data, 1.2.2.1

forecasts, 1.2.3.2

gauges, 1.2.1.1, 2.8.1

graphs, 1.2.1.3

in Excel, 1.3.3

interactive, 1.2.2.2, 1.2.2.2, 1.2.2.3, 1.3.2, 2.8.2

market basket analysis, 1.2.4.3, 2.5

models, 1.2.3.2

moving averages, 1.2.3.1

performance, 2.4.3.3

predicting customer behavior, 1.2.2.4

printing, 1.3.4, 2.8.3

publishing in XML, 1.3.5

ranking data, 1.2.1.4

scheduling, 1.3.6

sharing, 1.3

sorting data, 1.2.1.4

stoplight formatting, 1.2.1.2

tools for creating, 2.6

trend analysis, 1.2.3.1

what-if analysis, 1.2.4.1

Reports Builder, 2.6.1

S

SAP data, 2.1.1.1

scheduling reports, 1.3.6

share calculations, 2.4.3.1, 2.4.3.3

shipping labels, 2.6.1

sorting data, 1.2.1.4

source data, 2.1.1

mapping to target data, 2.1.2

Spreadsheet Add-Ins

for predictive analytics, 2.6.4

spreadsheets, 1.3.3, 2.6.3, 2.6.4

SQL Server data, 2.1.1.1

star schemas

described, 2.3.2

OLAP metadata, 2.4.2

statistical functions in Oracle Database, 1.1.3

stoplight formatting, 1.2.1.2

summarization

OLAP and relational, 2.4.3.2

Sybase data, 2.1.1.1

T

target data

mapping to source, 2.1.2

third normal form, 2.2.1, 2.3.1

time-series analysis, 2.4.3.1, 2.4.3.3

transactional data, 1.1.1

data model, 2.2.1

trend analysis, 1.2.3.1

V

Viewer

see OracleBI Discoverer Viewer

W

Warehouse Builder

see OracleBI Warehouse Builder

Web servers, 2.7, 2.8.1

what-if analysis, 1.2.4.1

worksheets, 2.6.2

X

XML

publishing reports, 1.3.5