Index

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

A

Access, 4.3

access online help, 3.3.1

access to an OWB workspace, 2.2.1

ACCESS_PUBLICVIEW_BROWSER system privilege, 3.8

accessing and moving data, 4

accounts

OWBSYS and OWBSYS_AUDIT, 2.2

activity details

viewing for process flows, 3.8

activity types, 1.2.7

ADMINISTRATOR, 7.1.1

administrator usability, 1.2.5

advanced find, 1.3.1

ALL_OLAP2_AW views, 5.2.2.5

analytic MOLAP, 5.2.1

application

adaptors, 4.1

sources, ERP, 4.1

ASCII files, 4.4

attribute analysis, 8.6.1

attribute values for multiple configurations, 1.3.22

attributes

dimension attributes, 5.3.2.1

level attributes, 5.3.2.3

Auto Mapping dialog box, 1.3.26

automated corrections, 8.7

automated data cleansing, 8.7

automatic layout, 3.6

automation features, 10

B

basic metadata, 4.1

batch operations, 3.3.3

binary formats, 4.4, Glossary

Bird's Eye View, 7.5.1

browser listener, 3.3.1

Business Area Editor, B.2

business identifier, 5.3.2.2.2

business intelligence enhancements, 1.2.3

Business Intelligence node, 5.1

business names

business name mode, A.1.11.1

maximum length, A.1.11.1

requirements, A.1.11.1

syntax for business object names, A.1.11.1, A.1.11.1, A.1.11.1

C

Canvas, 3.6.1, 7.5.1

change management, 7.5

Change Manager, 3.3.1

character set, 4.4

check for updates, 2.4.1

chunking, 1.3.28

classes

Design Center, 3.3

Clipboard, 3.3.1

COBOL Copybooks, 1.3.21

code generation in mappings, 6.2

Code Template mappings, 1.3.4

Code Templates, 4.5

Code Templates (CT mappings), 6.2

collections, 3.2.3

deleting shortcuts in, 3.2.3

comma-separated, 4.4, Glossary

comments in operators, 1.3.24

complex transformation, 4.4.1

conditional operations, 3.3.3

configuration drop-down box, 1.3.6

configuration templates, 1.3.22

configuring groups of objects, 1.3.22

Connection Navigator, 4.2.1

connectivity

ODBC, 4.6

OLE DB drivers for heterogeneous data sources, 4.6

connectivity agent, 4.6, 4.6

connectors, 4.1

about, 4.2.1

Connectors Navigator of Locations, 3.5.2.1

CONSTRUCT, 1.3.20

context-sensitive help, 2.4

Control Center Agent, 1.3.18, 1.3.18

Control Center Manager, 3.4

copy and paste, 1.3.5

copying and moving metadata, 7.2

correction mappings, 8.7

correlated joins, 1.3.20

Create Business Area Wizard, B.2

Create Dimension Wizard, 5.2.2.1

Create Flat File Wizard, 4.4

credentials, 4.2.1

CRM, 4.1, 4.3

cube Data Viewer, 5.1.2

Cube Editor, B.2

cube-organized materialized views, 1.3.3

cubes, 5.6

default aggregation method, 5.6.1.2

dimensionality, 5.6.1.2

measures, 5.6.1.1

MOLAP implementation, 5.6.2.2

relational implementation, 5.6.2.1

ROLAP implementation, 5.6.2.1

solve dependency order, 5.6.3

current software release

version information, 2.4.1

current workspace session, 2.4.1

custom metadata stores, 4.1

D

data auditors, 8.4

data cleansing

automated, 8.7

data correction, 8.7.1.1

data correction, automatic, 8.7.1

data flow, 6.2

data matching, 8.8

Data Object Editor

components, 5.1.1

data object editors, 5.1.1

data objects

dimensional objects, implementing, 5.2.2.2

data profiling

about, 8.2

features in OWB, 8.5

types, 8.6

types, attribute analysis, 8.6.1

types, functional dependency, 8.6.2

types, referential analysis, 8.6.3

data quality

ensuring, 8.1

lifecycle, 8.1.1

management, 8.1

data rules

about, 8.3

custom profiling and, 8.6.4

data sources

Oracle Transparent Gateways, 4.6

Data transformation, 6.1

data type analysis, 8.6.1

Data Viewer, 3.3.1, 5.1.2

data viewer area, 3.6.1.8

database connector, 4.2.1

database dictionary and metadata, 4.1

DB2, 4.3

Debug Toolbar, 3.6.1.6

default naming mode, A.1.11.1

default project, 3.2

Dependency Manager, 1.3.16

deploying

about, 9.1.1

deployment status, 9.1.1.1

deploying a mapping, 9.1.1

deploying a process flow, 9.1.1

deployment, 4.7

deployment information

viewing to manage target environments, 3.8

Deployment Option configuration property, 5.2.2.2

Design Center, 1.3.23, 3.3, 3.6.1

classes not found, 3.3

Design menu, 3.3.1

Edit menu, 3.3.1

galleries, 3.3

menus, 3.3.1

toolbar, 3.3.2

Tools menu, 3.3.1

View menu, 3.3.1

Design Center, starting, 2.2.1

design decisions with OWB wizards, 3.7

design environment for Experts, 10.2.1

Design menu, 3.3.1

developer usability, 1.2.4

Diagram Toolbar, 3.6.1.6

differences between external tables and SQL*Loader, 4.4.2

dimension Data Viewer, 5.1.2

Dimension Editor, 5.2.2.1, B.2

dimension loading, 5.2.2.4

dimensional objects, 5.2

deployment options, 5.2.2.3

implementing, 5.2.2.2

dimensions

about, 5.3

business identifier, 5.3.2.2.2

control rows, 5.3.2.7

dimension attributes, 5.3.2.1

dimension roles, 5.3.2.5

hierarchies, 5.3.2.4

implementing, 5.3.3

level attributes, 5.3.2.3

level relationships, 5.3.2.6

levels, 5.3.2.2

orphan management policy, 5.2.2.6

parent identifier, 5.3.2.2.3

rules, 5.3.1

snowflake schema implementation, 5.3.3.2

star schema implementation, 5.3.3.1

surrogate identifier, 5.3.2.2.1

time dimensions, about, 5.5

value-based hierarchies, 5.3.2.8

dimensions and cubes, 5.2

display options for editors, 3.6.1.7

displaying Clipboard contents, 3.3.1

displaying generated scripts, 3.6.1.9

displaying preferences, 3.3.1

displaying the messages log area, 3.3.1

displaying validation messages for objects, 3.6.1.9

displaying welcome pages for wizards, A.1.5

DM Tree, 7.5.1

dockable panels, 3.6

domain analysis, 8.6.1

DRDA, 4.3

E

editor components, 3.6.1

editor display options, 3.6.1.7

editor modes, 3.6.1

editor toolbars, 3.6.1.6

editor windows, 3.6.1.1

editors, 3.6, 3.6.1

common components, 3.6.1

EJB/Java activity type in Process Flows, 1.3.30

enforcing data quality, 8.3

ensuring data quality, 8.1

ERP, 4.3

error details

viewing for ETL runtime, 3.8

errors

Extension tab, 3.3.1

EVERYONE, 7.1.1

Excel, 4.3

execution

about, 9.1.2

EXPAND, 1.3.20

Expert Editor, 10.2.1

Experts, 1.3.9

about, 10.2

design environment, 10.2.1

Guided Assistance, 10.3

storage, 10.2.2

expression editing, 1.3.10

extensible platform framework, 1.3.11

extensions, 2.4.1

Extensions tab, 3.3.1

external table update, 3.3.1

external tables

defined, 4.4.1

External Table option, 4.4.1

extracting existing metadata, 4.1

F

file object, 4.4

Flat File Sample Wizard, 4.4

flat files

as data sources, 4.4

as targets, 4.4

Create Flat File Wizard, 4.4

definitions, 4.4

operators, 4.4.2

what’s new, 1.3.7

foldering, 1.3.27

user folders, 1.3.25

folders, 3.2.2

functional dependency analysis, 8.6.2

Fusion Client Platform, 3.3

G

gallery

new, 3.6.1.4

Gallery, 3.3

Gateway, 4.6

Gateways, 4.6

DRDA, 4.6

Informix, 4.6

ODBC, 4.6

SQL Server, 4.6

Sybase, 4.6

Teradata, 4.6

General Toolbar, 3.6.1.6

generated scripts

displaying for selected object, 3.3.1

generating reports about workspace objects, 3.8

generation, 3.6.1.9

Generation panel, 3.6.1.9

Global Search, 3.3

Globals Navigator, 3.5.3

Go to File, 3.3

Go to Java Class, 3.3

government regulations, 7.6

GRAPHIC, 4.4

Graphical Navigator, B.1

grouping objects, 1.3.13

Guided Assistance Experts

about, 10.3

H

help

F1 key, 2.4

online documentation, 2.4

search, 2.4.1

Help Center, 2.4.2

Help menu, 2.4.1

heterogeneous audit, 1.3.14

heterogeneous databases, 1.2.1, 1.3.11

heterogeneous reporting, 1.3.14

hiding navigators, 3.3.1

hiding OMB*Plus, 3.3.1

hiding welcome pages for wizards, A.1.5

hierarchies

about, 5.3.2.4

value-based hierarchies, 5.3.2.8

highlights, 1.1

I

IDE, 1.3.23, 3.3

impact analysis

displaying on metadata, 3.3.1

implementing

dimensional objects, 5.2.2.2

MOLAP cubes, 5.6.2.2

relational cubes, 5.6.2.1

ROLAP cubes, 5.6.2.1

snowflake schema, 5.3.3.2

star schema, 5.3.3.1

Import Metadata Wizard

metadata

Import Metadata Wizard, 4.1.1

import wizard

Metadata Import Wizard, 4.1.1

importing source metadata, 4.1

improving execution time, 3.3.1

Indicator Bar, 3.6.1

Informix, 4.3

Integrated Development Environment (IDE), 1.3.23

intelligence objects, 5.1

Item Folder Editor, B.2

J

J2EE User Management window, 3.3.1

Jacl, 10.1

JAR files, 10.2.1

Java-based (J2EE) Control Center Agent, 1.3.18

Java-based runtime environment, 1.3.18

JDBC connectivity support, 1.3.4

JDev-based IDE, 3.6.1.4

JDeveloper-style user interface, 1.3.23

JDev-style editors, 3.6

Job Monitor, 3.3.1

job scheduling, 9.4

Join operator, 1.3.33

K

Key Lookup operator, 1.3.19

L

large updates, 1.3.28

large volumes of data, 4.4.2

levels

dimension, 5.3.2.2

lifecycle of a data system, 9.2

lineage analysis

displaying on metadata, 3.3.1

Lineage and Impact Analysis (LIA), 7.6.1

lineage diagram, 7.6.1

locale

setting, 2.2.2

locations, 1.3.17, 4.2

Locations Navigator, 3.5.2

locations registered in multiple Control Centers, 1.3.15

logging in to a workspace, 3.1

logical name mode See business name mode

logical names See business names, A.1.11.1, A.1.11.1

logs, message log preferences, A.1.9

LONG data type, 1.3.31

M

mainframe sources, 4.1

manage J2EE users, 3.3.1

managing data quality, 8.1

managing multiple configurations, 1.3.22

managing OWB locations, 1.3.17

mapping

nested, 6.4

Mapping Connection dialog box, 1.3.26

Mapping Editor

about, 3.6

components, 3.6.1

toolbars, 3.6.1.6

windows, 3.6.1.1

Mapping Generation Languages, 6.3

Mapping Navigator, 3.6.1.2

mapping operator, 6.3

mapping operators

about, 6.2

mappings

about, 6.2

designing, 6.5

pluggable, 6.4

matching, 8.8

Materialized View Editor, B.2

MDL export, 7.3

Menu Bar, 3.6.1

merging, 8.8

message log preferences, A.1.9

Message tab, 3.6.1.9

Messages area, 3.3

messages log

displaying, 3.3.1

metadata

about, 4.1

and database dictionary, 4.1

dependencies, 7.6

security, 7.1

stores, custom SQL or XML, 4.1

metadata dependencies, diagrams of, 7.6

Metadata Dependency Manager, 3.3.1, 7.6, 7.6

Metadata Dependency Manager (MDM), 7.5

Metadata Loader (MDL)

using, 7.3

Metadata Loader utility, 7.2

metadata search and find, 1.3.15

modes

business name mode, A.1.11.1

logical name mode See business name mode

naming mode, default, A.1.11.1

physical name mode, A.1.11.1

modules, 3.2.1, 3.2.1

about, 4.2

Create Module Wizard, 4.2

Transportable, 4.7

MOLAP, 5.2.1

MOLAP implementation, 5.2.1

monitoring data quality, 8.4

monitoring quality, 1.3.14

moving large volumes of data, 4.7

multiple configuration management, 1.3.22

multiple projects, 3.2

N

names

business name mode, A.1.11.1

business object names, syntax for, A.1.11.1, A.1.11.1, A.1.11.1

default naming mode, A.1.11.1

logical name mode See business name mode

physical name mode, A.1.11.1

physical object names, syntax for, A.1.11.1

naming

modes, default naming mode, A.1.11.1

objects, business name mode, A.1.11.1

objects, logical name mode See business name mode

objects, physical name mode, A.1.11.1

setting naming preferences, A.1.11

transformation names, A.1.11.1

Naming Mode, 3.6.1

native ABAP code, 4.3

navigators, 3.5

nested Experts, 10.2.1

Nested Table Editor, B.2

nested user folders, 1.3.25

new feature, 1.1

New Gallery, 3.6.1.4

NFS, 4.4

node, 4.2

SAP, 4.2

non-Oracle database systems

as data sources, 4.5, 4.6

non-Oracle databases, 4.6

O

OBI EE, 5.1

object lookups using synonyms, 4.1.1

Object Type Editor, B.2

objects

syntax for business names, A.1.11.1

syntax for logical names, A.1.11.1, A.1.11.1

syntax for physical names, A.1.11.1

OC4J 10.3.3, 1.3.27

ODBC, 4.3

ODBC Data Source Administrator, 4.3

ODBC for heterogeneous data sources, 4.6

OLAP catalog, 5.2.2.5

OLAP cube storage, 1.3.3

OLAP metadata, 5.2.2.5

OLAP option, 5.2.2.2

OLAP uses, 5.2.1

OLE DB drivers for heterogeneous data sources, 4.6

OMB*Plus, 3.3.3, 10

command window, 3.3.3

OMB*Plus activity type in process flows, 1.3.32

OMB-prefixed commands, 10.1

OMU-prefixed commands, 10.1

opening multiple editors, 1.3.23

operator comments, 1.3.24

operator palette, 3.6.1.5

operators

locating, 3.6.1.5

operators, mapping, 6.2

Optimize Repository, 3.3.1

optimizing the repository, A.1.5

options for Oracle Warehouse Builder, 2.1

Oracle Business Intelligence Suite Enterprise Edition (OBI EE), 1.3.2, 4.3, 5.1

Oracle Database release 8.1, 4.3

Oracle Database XE, 2.1

Oracle Discoverer, 5.1

Oracle Gateways, 4.6

Oracle Heterogeneous Services (Gateways), 4.3

Oracle JDeveloper, 1.3.23

Oracle SQL Developer, 1.3.23

Oracle target module, 3.2.1

Oracle Technology Network, 2.4.1

Oracle Transparent Gateways, 4.6

Oracle Warehouse Builder Utility Exchange, 2.4.1

Oracle Workflow, 4.3

organizing objects, 1.3.25

orphan management, 1.3.12

orphan management policy, 5.2.2.6

OWB locations, 1.3.17

OWB on OTN, 2.4.1

OWB product updates, 2.4.1

OWB Utility Exchange, 2.4.1

OWBSYS and OWBSYS_AUDIT accounts, 2.2

P

Palette, 3.6.1.5

Palette Toolbar, 3.6.1.6

parallelizing large table updates, 1.3.28

parent identifier, 5.3.2.2.3

pattern analysis, 8.6.1

Peoplesoft, 4.3

Peoplesoft application data, 1.3.31

performance

improving, 3.3.1

phases in the data quality lifecycle, 8.1.1

physical names

physical name mode, A.1.11.1

syntax for physical object names, A.1.11.1

plain text files, 4.4, Glossary

platform extensibility, 1.3.11

PL/SQL, 6.2

PL/SQL code, 1.3.24

pluggable mapping, 6.4

pluggable mappings

embedded, 6.4

reusable, 6.4

preferences

displaying welcome pages for wizards, A.1.5

message log preferences, A.1.9

naming preferences, A.1.11

private Experts, 10.2.2

privileged user, 4.2.1

process flows, 1.2.7

profile

displaying, 3.3.1

projects, 3.2

Projects Navigator, 3.5.1

Properties Inspector, 3.6.1.3

property inspector, 3.6

Property Inspector, 7.5.1

public Experts, 10.2.2

public Experts folder, 10.3

Public Transformations node, 6.5.2

public views, 9.3

Q

quality

assessment, 8.1.1.1

design, 8.1.1.2

monitoring, 8.1.1.4

transformation, 8.1.1.3

Quick Mapper, 1.3.26, 1.3.26

quick search field, 3.6.1.5

Quick Start, 2.2

R

RAW, 4.4

Read/Write Mode, 3.6.1

record types, 4.4

Recycle Bin, 3.3.1

referential analysis, 8.6.3

refresh repository, 1.3.29

relational and dimensional data objects, 5.1

relational implementation, 5.2.1

relational ROLAP, 5.2.1

Rename Mode, 3.6.1

rename MY_PROJECT, 2.2.2

Repository

optimizing, A.1.5

Repository Browser, 1.3.27, 3.8

displaying in default Web browser, 3.3.1

opening, 3.8

Repository Browser changes, 1.3.27

Repository Browser or Heterogeneous Repository Browser, 9.3

repository optimization, 3.3.1

Repository upgrades, 1.3.29

requirements

for business names, A.1.11.1

reusable transformations, 6.5.2

ROLAP, 5.2.1

ROLAP implementation, 5.2.1

roles

dimension roles, 5.3.2.5

runtime auditing, 9.3

S

SAP ABAP, 6.2

SAP node, 4.2

SAP R/3 system, 4.2

SCDs

see slowly changing dimensions

scenarios, 2.1.1

schema correction, 8.7.1.1

Script tab, 3.6.1.9

scripting language, 10.1

OMB*Plus, 3.3.3

Security folder, 3.5.3

security interface

about, 7.1.1

security node, 7.1.1

session properties, 2.4.1

setting

locale, 2.2.2

message log preferences, A.1.9

naming preferences, A.1.11

wizard preferences, A.1.5

Siebel, 4.3

Six Sigma

formula, 8.6.5.1

methodology, 8.6.5

metrics, 8.6.5.2

slowly changing dimensions

about, 5.4

type 1, 5.4.1

SMALLINT, 4.4

snapshots, 7.2

uses, 7.4

using, 7.4

SOA, 1.2.2, 1.2.7

SOA integration, 1.3.34

SOA-style architectures, 1.2.2

sources

mainframe, 4.1

sources and targets

supported, 4.3

SQL DML statement, 4.4.1

SQL Server, 4.3

SQL*Loader, 4.4.2, 6.2

SQL*Loader code, 4.4.2

SQL*Plus code, 1.3.31

SQL*Plus window, 3.3.1

staging table, 4.4.2

Start Page, 2.2

starting the Design Center, 2.2.1

STARTUP

folder, 10.3

storage of Experts

public and private, 10.2.2

structure panel

See editors, B.2

subqueries, 1.3.33

supported sources and targets, 4.3

surrogate identifier, 5.3.2.2.1

Sybase, 4.3

syntax

for business object names, A.1.11.1

for logical object names, A.1.11.1, A.1.11.1

for physical object names, A.1.11.1

T

Table Editor, B.2

table functions, 1.3.8

tab-separated format, 4.4, Glossary

Tcl language, 10.1

TCP/IP, 4.4

Teradata, 4.3

time dimensions

about, 5.5

timings

viewing for mappings and process flows, 3.8

Title Bar, 3.6.1

Toolbar, 3.6.1

training, 2.4.1

transformation, 6.1

transformation capabilities, 1.2.6

transformation libraries

global shared library, 6.5.2

Oracle library, 6.5.2

transformation library, 6.5.2

transformations

about, 6.5

names, unique, A.1.11.1

types of, 6.5

Transportable modules, 4.7

troubleshooting OWB-generated code, 1.3.24

U

unique

transformation names, A.1.11.1

unique key analysis, 8.6.1

update external table, 3.3.1

upgrade repository, 1.3.29

use cases, 2.1.1

user ID, 4.2.1

user interface, 3

user interface framework, 1.3.23

user preferences

displaying, 3.3.1

user-defined types

importing, 4.1.1

uses for OLAP, 5.2.1

V

Validation Mode, 3.6.1

validation results

displaying, 3.3.1

VARRAY, 1.3.20

VArray Editor, B.2

version and history management, 7.2

version information, 2.4.1

View Editor, B.2

viewing design details, 3.8

viewing metadata properties, 3.8

W

Web Service, 1.3.34

Web-based access to workspaces, 3.8

wizards, 3.7

welcome pages, displaying, A.1.5

Workspace, 3.1

workspace access, 3.1

workspace session, 2.4.1

X

XPDL, 9.1.1