Oracle9i Warehouse Builder User's Guide -- Index

ABAP

ABAP, defined in glossary, 1-1

directory storing scripts, 21-30

extension for scripts, 21-30

run parameter file, 21-30

scripts, buffer directory, 21-30

scripts, directory, 21-30

scripts, extension, 21-30

scripts, generating, 21-28

spool directory, 21-30

access

ending read/write mode, 2-16

folder-in-use locks, 2-15

managing access to repositories, Runtime Audit Browser, 14-10

multiple-user access, about, 2-15

read-only mode, 2-16

read/write mode, 2-16

write locks on objects, 2-15

access parameters

for external tables, 3-34

access specifications

for external tables, 5-18

activities

about, 10-10

adding to process flows, 10-10

AND, 10-17

binding to parameters, 10-12

connecting, 10-15

Email, 10-18

End, 10-19

External Process, 10-22

File Exists, 10-24

Fork, 10-24

FTP, 10-25

list of, 10-16

Mapping, 10-27

OR, 10-28

parameters, 10-11

passing in values, 10-12

Start, 10-28

Subprocess, 10-29

Transform, 10-30

adding

attribute sets, 3-23

attributes to mappings, 6-15

custom reports to a role, 18-17

data flow operators to mappings, 6-8

database links, Runtime Audit Browser, 14-11

groups to mappings, 6-14

metadata, 15-15

operators to mappings, 6-8

portlets to the Warehouse Builder Browser, 18-6

source operators to mappings, 6-10

table columns, 3-17

target operators to mappings, 6-10

utilities to the utility drawer, 2-28

administration

portlet, 18-3

roles, Runtime Audit Browser, 14-13

Runtime Audit Browser, 14-9

administrator list

maintaining, Runtime Audit Browser, 14-14

advanced attribute set properties, 3-24

Advanced Queue operator, 8-26

example, 8-27

prerequisites for mapping execution, 8-28

properties, 8-28

reconciling advanced queues, 8-27

using, 8-27

advanced queues, 3-47

about, 3-47, 3-48

Advanced Queue operator properties, 8-28

advanced queue, defined in glossary, 1-2

configuring, 5-20

creating, 8-27

example, 8-27

importing, 3-49

messages, 3-49

payload, 3-48

prerequisites for mapping execution, 8-28

properties, 3-52

reconciling, 8-27

reimporting, 3-51

See also Advanced Queue operator

advanced reconcile options, 3-52, 4-16

agents

agent, defined in glossary, 1-2

connectivity agent, defined in glossary, 1-6

transparent gateways, 4-6

aggregation

aggregation, defined in glossary, 1-2

mixed levels, 3-57

Aggregator operator, 8-5

aggregate, defined in glossary, 1-2

aggregation, defined in glossary, 1-2

ALL, 8-5

DISTINCT, 8-5

GROUP BY, 8-5

HAVING, 8-5

ALL

in the Aggregator operator, 8-5

ALTER

metadata snapshots, 16-16

altering

metadata snapshots, 16-16

analytic workspace, 22-16

loading, 22-26

OLAP DML, 22-16

analytic workspaces

analytic workspace, defined in glossary, 1-2

analyzing

statistics and targets, 11-6

table estimate percent, 5-14

ancestors

ancestor, defined in glossary, 1-2

API

API, defined in glossary, 1-3

AQ See advanced queues

architecture

client, defined in glossary, 1-5

database server, defined in glossary, 1-9

archiving

archive, defined in glossary, 1-3

differences between archive and export, 15-12

project version labels, 15-12

projects, about, 15-11

projects, instructions, 15-12

attribute properties

load column when deleting row, 6-35

load column when inserting row, 6-39

load column when updating row, 6-35, 6-39

match column when deleting row, 6-40

match column when updating row, 6-35, 6-39

attribute sets

attribute sets, defined in glossary, 1-3

attributes

adding to mappings, 6-15

attribute sets, adding, 3-23

attribute sets, defined in glossary, 1-3

attribute, defined in glossary, 1-3

connecting in mappings, 6-21

datatype, defined in glossary, 1-9

deleting from mappings, 6-15

editing, 6-13

naming conventions, 6-16

properties, 6-30, 6-37

renaming, 6-13

See also attribute properties

auditing

deployment and execution, 14-1

Runtime Audit Browser, 14-2

runtime audit reports, 14-15

auto mapping

See connecting

AW see analytic workspace, 22-16

backup

importing and exporting with the Metadata Loader (MDL), 15-1

metadata change management using snapshots, 16-1

backups

archive metadata, defined in glossary, 1-3

base language

base language, defined in glossary, 1-3

setting, 2-23

binding

flat file source operators, 8-32

flat file target operators, 8-32

in process flows, 10-12

bitmap indexes

impact report for bitmap index creation, 5-5

bound names, 6-17, 6-32

bridges

bridge, defined in glossary, 1-4

versions, 22-9

bulk processing, 11-6, 11-7

bulk size, 11-5, 11-6

business intelligence, 22-16

Business Intelligence tools

integration, Transfer Wizard, 22-5

business names

business name mode, 2-24

maximum length, 2-25, 6-17

requirements, 2-25, 6-17

syntax for business object names, 2-25

CASS reporting

about, 8-90

restrictions, 8-91

change management

about metadata snapshots, 16-2

See also metadata history management

CHAR, 3-18

in the Transformation operator, 8-116

character sets, 4-34

in external tables, 5-19

multibyte, 5-19

check keys, 3-20

CHECK/INSERT, 6-33

cleansing

cleansing, defined in glossary, 1-5

clients

client, defined in glossary, 1-5

clipboard

preferences, 2-31

cluster tables, 21-2

code generation

configuring target directories, 5-11

code viewer

SAP, 21-33

collections

about, 22-22

collection, defined in glossary, 1-6

creating, 22-3

defining for OLAP, 22-22

deleting shortcuts in, 22-3

editing, 22-4

New Collection Wizard, 22-3

colors

general preferences, 2-21

columns

column, defined in glossary, 1-6

datatype, defined in glossary, 1-9

command line utilities

importing metadata, 15-32

commit

commit, defined in glossary, 1-6

design changes, 2-15

frequency, 11-6

synchronizing changes to locked objects, 2-16

commit strategies, 11-24

committing to multiple targets, 11-23

correlated commit, 11-24

independent commit, 11-24

Common Warehouse Model

Common Warehouse Model, defined in glossary, 1-6

comparing

metadata snapshot comparison reports, 16-18

snapshot comparison reports, 16-19

compressing

mappings, 6-20

conditional loading settings

delete target condition, 6-34

target filter for update, 6-34

configuration properties

ABAP directory, 5-12

ABAP extension, 5-12

ABAP run parameter file, 5-12

ABAP spool directory, 5-12

analyzing statistics and targets, 11-6

analyzing table estimate percent, 5-14

archive directory, 5-12

bulk processing, 11-7

commit frequency, 11-6

DDL directory, 5-12

DDL extension, 5-12

DDL spool directory, 5-12

default audit level, 11-5

default index tablespace, 5-11

default object tablespace, 5-11

default purge group, 11-6, 11-19

dimension, 5-22

end of line, 5-11

hints, 11-10

input directory, 5-11

invalid directory, 5-11

lib directory, 5-12

lib extension, 5-12

lib spool directory, 5-12

loader directory, 5-13

loader extension, 5-13

loader run parameter file, 5-13

log directory, 5-12

logging mode, 5-14

maximum number of errors, 11-6

parallel, 5-15, 5-18

partition exchange loading, 11-10

PL/SQL directory, 5-12

PL/SQL extension, 5-12

PL/SQL Generation Mode, 5-11

PL/SQL run parameter file, 5-12

PL/SQL spool directory, 5-12

receive directory, 5-11

sequences, 5-26

sort directory, 5-12

SQL*Loader parameters, 6-33

tablespace, 5-15

using index, 5-15

work directory, 5-12

configuring

advanced queues, 5-20

connections for database sources, 4-5

conventional views, 5-26

cubes, 5-22

default audit level, 11-5

dimensions, 5-22

external tables, 5-15

flat file physical properties, 11-13

flat file targets, 11-13

for PEL, 11-31

indexes, 5-5

mapping runtime parameters, 11-4

mapping sources and targets, 8-111, 11-9

mappings, 11-2

master-detail mappings, conventional path load, 8-40

master-detail mappings, direct path load, 8-45

materialized views, 5-23

partitions, 5-6, 5-8

partitions, DDL

PL/SQL mappings, 11-20

process flows, 11-41

runtime parameters, 5-9

runtime parameters, SAP files, 21-29

SAP file physical properties, 21-26

SAP, loading type parameter, 21-26

sequences, 5-26

tables, 5-13

updating utilities, 2-29

validating objects, 12-2

warehouse modules, 5-10

connecting

attributes in mappings, 6-21

connection, defined in glossary, 1-6

connector, defined in glossary, 1-6

database link, defined in glossary, 1-8

groups in mappings, 6-23

operators in mappings, 6-21

connection information

non-Oracle database systems, 4-6

remote function call (RFC), 21-8

SAP application, 21-7

source modules, 4-5

connection type, 21-8

connections

defining Runtime Repository connections, 13-2

updating connection information, 4-20

connectivity

connection, defined in glossary, 1-6

connectivity agent, defined in glossary, 1-6

database link, defined in glossary, 1-8

ODBC, 4-4

OLE DB drivers for heterogeneous data sources, 4-4

connectivity agent, 4-4

connectors

about, 3-6

connector, defined in glossary, 1-6

creating, 3-7

database link, defined in glossary, 1-8

defining, 3-6

editing, 3-8

console

clipboard, defined in glossary, 1-5

collection, defined in glossary, 1-6

console, defined in glossary, 1-7

Constant operator, 8-9

constraint

cube table foreign key references, 3-67

unique key constraint on levels, 3-56

Constraint operator

constraint, defined in glossary, 1-7

constraints

check key, 3-20

constraint, defined in glossary, 1-7

cube foreign key references, 3-68

DEFAULTIF, Flat File Sample wizard, 4-48

defining, 3-20

deleting, 3-23

editing, 3-20

foreign key, 3-20

match by options, 6-34

NULLIF, in the Flat File Sample wizard, 4-48

primary key, 3-20

unique key, 3-20

containers

Oracle Designer Repository, 4-21

SAP application, 21-4

source modules, 4-2

conventional path loading

for master-detail relationships, 8-37

master-detail flat files, sample mapping, 8-40

conventional views

configuring, 5-26

renaming, 3-38

converting

full snapshots to signature, 16-3

Copy and Map Wizard

using, 21-22

correlated commit, 11-24

design considerations, 11-26

create definition

hierarchy, 3-63

transformation, 9-6

creating

advanced queues, 8-27

collections, 22-3

connectors, 3-7

custom reports in Browser, 17-26

database links, 4-6, 18-12

dimensions, 3-58

indexes, 5-2

locations, 3-4

mappings, 6-1

mappings, New Mapping Wizard, 6-2

objects in a project, 2-32

objects, bound name, defined in glossary, 1-4

objects, business name, defined in glossary, 1-4

OLAP metadata, 22-18

Oracle Designer 6i source modules, 4-22

physical objects, 5-10

process flows, 10-3

projects, 2-32

Runtime Repository connections, 13-3

source modules, 4-2

time dimension, 3-67

time dimensions, 3-66

Cross Reference Output, 8-57

cube tables, 3-67

defining foreign key references, 3-68

physical aspects, 3-67

property sheet, 3-70

update definition, 3-70

cubes, 3-67

configuring, 5-22

cube, defined in glossary, 1-7

defining, 3-67

defining for OLAP, 22-21

derived fact (or measure), defined in glossary, 1-10

dimension, defined in glossary, 1-10

editing, 3-70

New Cube Wizard, 3-67

customizing

Browser favorites page, 17-22

viewing custom Browser reports, 17-26

CWM, 22-2

CWM, defined in glossary, 1-6

Data Definition Language (DDL)

DDL, defined in glossary, 1-7

data definition language (DDL)

configuring partitions

data flow operators

data flow operator, defined in glossary, 1-7

Data Generator operator, 8-11

for extracting from master-detail flat files, 8-43

RECNUM, 8-11

SEQUENCE, 8-12

SYSDATE, 8-12

using, 8-13

Data Manipulation Language (DML)

DML, defined in glossary, 1-7

data manipulation language (DML)

DML, defined in glossary, 1-11

data marts

data mart, defined in glossary, 1-8

data movements

DML, defined in glossary, 1-11

data quality

Match-Merge operator, 8-53

data sources, 4-1

cleansing, defined in glossary, 1-5

data source, defined in glossary, 1-8

defining SAP objects, 21-3

Oracle Designer 6i, 4-21

Oracle Heterogeneous Services, 4-4

Oracle Transparent Gateways, 4-4

See also sources

updating connection information, 4-20

data transformation, 8-1

data type

in the Transformation operator, 8-116

data types

CHAR, 3-18

DATE, 3-18

flat file field, 4-47

FLOAT, 3-19

NUMBER, 3-19

portable, 4-47

tables, 3-18

VARCHAR, 3-19

VARCHAR2, 3-19

data warehouses

cube, defined in glossary, 1-7

data mart, defined in glossary, 1-8

data warehouse, defined in glossary, 1-8

derived fact (or measure), defined in glossary, 1-10

dimension, defined in glossary, 1-10

database links

adding, Runtime Audit Browser, 14-11

New Database Link dialog, 4-6

Oracle database system, 4-6

SAP, 21-7

source modules, 4-5

viewing, Runtime Audit Browser, 14-11

databases

client, defined in glossary, 1-5

column, defined in glossary, 1-6

commit, defined in glossary, 1-6

configuring database source connections, 4-5

connection, defined in glossary, 1-6

connectivity agent, defined in glossary, 1-6

constraint, defined in glossary, 1-7

data warehouse, defined in glossary, 1-8

database link, defined in glossary, 1-8

database object, defined in glossary, 1-9

database server, defined in glossary, 1-9

database source modules, about, 4-6

database, defined in glossary, 1-8

denormalize, defined in glossary, 1-9

importing definitions from, 4-11

non-Oracle database systems, 4-6

reimporting definitions, 4-14

datatypes

datatype, defined in glossary, 1-9

DATE, 3-18

DDL See data definition language

debugging

OLAP metadata export, 22-26

Deduplicator operator, 8-14

DISTINCT, 8-14

default audit level

configuration properties, 11-5

default purge group, 11-6, 11-19

DEFAULTIF

constraint, Flat File Sample wizard, 4-48

defaults

audit level, configuration properties, 11-5

naming mode, 2-25

operating mode, 11-4

defining

collections for OLAP, 22-22

connectors, 3-6

constraints, 3-20

cubes, 3-67

cubes for OLAP, 22-21

dimensions, 3-58

dimensions for OLAP, 22-18

display sets, 6-18

ETL process for SAP objects, 21-20

locations, 3-3

mappings, 6-1, 6-2

mappings containing SAP objects, 21-20

mappings, New Mapping Wizard, 6-2

materialized views, 3-40

relational objects, 3-9

Runtime Repository connections, 13-2

SAP objects, 21-3

sequences, 3-44

tables, 3-11

updating flat file definitions, 4-49

updating source definitions, 4-19

validating objects, 12-2

views, 3-35

definition

attribute, 3-61

transformation, 9-6

warehouse key column, 3-63

definitions

glossary of terms, 1-1

importing definitions from a database, 4-11

reimporting database definitions, 4-14

validating, 12-2

DELETE, 6-33

DELETE/INSERT, 6-33

deleting

attributes from mappings, 6-15

constraints, 3-23

groups from mappings, 6-14

delimited flat files

importing, 4-35

delimiters

delimited flat file, defined in glossary, 1-9

delimiter, defined in glossary, 1-9

deploying

about, 13-1

auditing deployment, 14-1

auditing with Runtime Audit Browser, 14-2

completing deployment, 13-17

connector, defined in glossary, 1-6

Deployment Manager, defined in glossary, 1-10

deployment tree, 13-7

deployment, defined in glossary, 1-10

executing deployed objects, 13-18

objects, 13-5

objects from the navigation tree, 13-5

objects with the Deployment Manager, 13-5

OLAP metadata, 22-22

PL/SQL scripts for transparent tables, 21-38

prerequisites, 13-2

saving deployment scripts, 13-18

selecting objects for deployment, 13-16

target systems, 13-2

using metadata snapshots during deployment, 16-21

viewing deployment history, 13-17

viewing deployment schedule reports, 14-6

viewing location reports, 14-7

viewing object summary reports, 14-7

deployment

cube, defined in glossary, 1-7

database link, defined in glossary, 1-8

Deployment Manager

about, 13-2, 13-6

deploying objects with, 13-5

Deployment Manager, defined in glossary, 1-10

deployment tree, 13-7

Details tab, 13-9

History tab, 13-10

opening, 13-6

saving deployment scripts, 13-18

selecting objects for deployment, 13-16

toolbar, 13-11

using, 13-6

viewing deployment history, 13-17

describing

flat files in the Flat File Sample Wizard, 4-33

design repository

design repository, defined in glossary, 1-10

Designer 6i, 4-21

workareas, 4-21

dialog

folder, 21-13

Dimension

Hierarchies, 3-55

dimension

attribute definition, 3-61

basic definition, 3-55

define a level of aggregation, 3-60

denormalized dimension table, 3-57

dimension object, 3-55

hierarchies, 3-62, 3-63

levels, 3-56

products

create, 3-58

property sheet, 3-65

table property sheet, 3-66

time dimension, 3-66

update, 3-64

dimension table

physical aspects, 3-55

dimensional objects, 3-9

dimensions, 3-55

configuring, 5-22

creating, 3-58

creating time dimensions, 3-66

defining, 3-58

defining for OLAP, 22-18

dimension value, defined in glossary, 1-10

dimension, defined in glossary, 1-10

editing, 3-64

editor, 3-64

New Dimension Wizard, 3-58

property sheet, 3-65

direct path loading

for master-detail relationships, 8-42, 8-43

master-detail flat files, sample mapping, 8-45

display sets

about, 6-18

defining, 6-18

selecting, 6-20

using, 6-18

displaying

Process Flow Editor, 10-8

properties, 2-35

setting the display language, 2-22

welcome pages for wizards, 2-21

DISTINCT, 6-6

in the Aggregator operator, 8-5

in the Deduplicator operator, 8-14

Dual Address Assignment

Name-Address operator, 8-81

editing

attributes in mappings, 6-13

collections, 22-4

connectors, 3-8

constraints, 3-20

cubes, 3-70

dimensions, 3-64

groups, 6-13

invalid objects, 12-7

locations, 3-5

mappings, 6-3

materialized views, 3-43

objects, 2-32

operators, 6-13

process flows, 10-5

repository information in Runtime Audit Browser, 14-11

Runtime Repository connections, 13-4

sequences, 3-45

tables, 3-14, 3-16

using object editors, 2-35

views, 3-38

editor

dimension, 3-64

materialized view editor, 3-43

editors

object editors, using, 2-35

endian, 5-19

ETL See Extraction Transform and Load

EXECUTE ALL PROCEDURES, 2-12

executing

auditing execution, 14-1

auditing with Runtime Audit Browser, 14-2

deployed objects, 13-18

deployment, defined in glossary, 1-10

mappings, 13-18

process flows, 13-18

selecting objects to execute, 13-18

viewing execution reports, 14-7, 14-8

viewing execution schedule reports, 14-8

viewing execution summary reports, 14-8

viewing trace reports, 14-9

export

log file, 22-15

exporting

bridge, defined in glossary, 1-4

differences between archive and export, 15-12

log file, 22-13

metadata in Warehouse Builder client, 15-9

metadata snapshots, 16-17

metadata using bridges, 22-13

metadata using the Transfer Wizard, 22-13

metadata, about, 15-7

metadata, at the command line, 15-28

Expression operator, 8-14

external tables

about, 3-26

access parameters, 3-34

access specifications for, 5-18

configuring, 5-15

creating, 3-27

editing, 3-32

editor, 3-29

External Table Wizard, 3-27

properties, 5-15

reconciling, 3-30

trimming settings, 5-19

using, 3-25

versus flat file operators, 3-26

versus SQL*Loader, 3-26

Extract Transform and Load (ETL), 6-1

extracting

cleansing, defined in glossary, 1-5

data source, defined in glossary, 1-8

from master-detail flat files, 8-34, 8-36

facts

additive facts, defined in glossary, 1-1

facts See cubes

fast refresh, 5-25

favorites

filtering Browser favorites, 17-21

portlets, 17-3

FCO

See first class objects (FCOs)

fields

delimiter, defined in glossary, 1-9

Filter operator, 8-15

WHERE, 8-15

filters

favorites, 17-21

filtering data with a transform, 9-6

Find

finding objects, 2-37

finding

objects by searching the navigation tree, 2-37

objects in a project, 2-37

first class objects (FCOs)

about, 1-5

glossary definition, 1-14

Flat File Sample Wizard, 4-32

describing the flat file, 4-33

field properties, 4-45

file format, 4-38

file layout, 4-37

fixed length flat files, 4-43

multiple-record-type files, 4-39

record organization, 4-34

using, 4-32

flat files

about flat file modules, 4-26

as sources and targets, 4-29

character sets, 4-34

configuring flat file properties, 11-13

configuring flat file targets, 11-13

configuring master-detail mappings, conventional path load, 8-40

configuring master-detail mappings, direct path load, 8-45

delimited, 4-38

delimited flat file, defined in glossary, 1-9

delimiter, defined in glossary, 1-9

enclosures, 4-39

extracting master and detail records, 8-36

field delimiters, 4-38

field properties, 4-45

fixed length, 4-43

Import Metadata Wizard, 4-30

importing, 4-30

importing master-detail flat files, 8-37

logical records in, 4-35

mapping sources, 11-13

mapping targets, 11-13

master-detail mappings, post-update scripts for direct path loads, 8-46

master-detail, example, 8-34

master-detail, extracting from, 8-34

master-detail, operations after initial load, 8-47

multiple record types in, 4-39

record delimiters, 4-35

residing on different operating systems, 4-27

sampling, 4-32

source operators, about, 8-30

source operators, importing/binding, 8-32

source operators, previously imported, 8-32

SQL properties, 4-48

SQL*Loader datatypes, 4-47

SQL*Loader properties, 4-47

target operators, about, 8-30

target operators, importing/binding, 8-32

target operators, inserting new, unbound, 8-33

target operators, multiple record types, 8-32

target operators, previously imported, 8-32

updating formats for, 4-49

FLOAT, 3-19

Folder Dialog, 21-13

folder-in-use locks

on objects, 2-15

folders

folder-in-use locks, 2-15

project navigation tree, 2-18

foreign keys, 3-20

defining, for cubes, 3-68

full outer joins

in the Joiner operator, 8-22

full snapshots

about, 16-3

converting to signature snapshots, 16-3

full, cascade snapshots, 16-4

full, no cascade snapshots, 16-4

gateways

transparent, 4-6

generated code

viewing SAP code, 21-33

generating

about, 12-7

code generation, defined in glossary, 1-5

configuring SAP file physical properties, 21-26

snapshot comparison reports, 16-19

generation

about, 12-7

Generation Mode dialog, SAP, 21-31

generation target directories, SAP, 21-30

glossary of terms, 1-1

GROUP BY

in the Aggregator operator, 8-5

Groups

Name-Address operator, 8-82

groups

adding to mappings, 6-14

connecting by name, 6-27

connecting by position, 6-27

connecting in mappings, 6-23

directions in, 6-14

editing in mappings, 6-13

naming conventions, 6-16

properties, 6-29

removing from mappings, 6-14

renaming, 6-14

HAVING

in the Aggregator operator, 8-5

heterogeneous data sources, 4-4

heterogeneous sources, 4-5

hiding

welcome pages for wizards, 2-21

hierarchies

child, defined in glossary, 1-5

create definition, 3-63

dimension, 3-62

hierarchy, defined in glossary, 1-16

hints, 11-10

history

about metadata snapshots, 16-2

Deployment Manager History tab, 13-10

See metadata history management

viewing deployment history, 13-17

history management

about metadata snapshots, 16-2

using metadata snapshots, 16-15

householding, 8-53, 8-72

Match-Merge operator, 8-53

ID column

rename as warehouse key column, 3-63

impact analysis

metadata snapshots, using with, 16-21

impact report for bitmap index creation dialog, 5-5

importing

advanced queues, 3-49

and binding flat file source operators, 8-32

and binding flat file target operators, 8-32

definitions, database systems, 4-11

differences between restore and import, 15-24

flat files, 4-30

Import Metadata Wizard, 4-11

Import Metadata Wizard, using, 4-30

Import Results dialog, 21-18

master-detail flat files, 8-37

metadata import modes, 15-21

metadata in Warehouse Builder client, 15-17

metadata matching criteria, 15-22

metadata snapshots, 16-17

metadata, about, 15-15

metadata, at the command line, 15-32

metadata, validation rules, 15-16

Oracle database metadata, 4-11

reimporting database definitions, 4-14

using snapshots with importing metadata, 16-21

importing metadata, 22-9

inbound reconciliation

for operators, 6-41

independent commit, 11-24

indexes

bitmap index, defined in glossary, 1-4

bitmap indexes, 5-5

configuring, 5-5

creating, 5-2

renaming, 5-6

INI file for SAP Integrator, 21-5

Input Attributes

Name-Address operator, 8-83

INSERT, 6-32

inserting

flat file target operators, new, unbound, 8-33

into multiple targets, 8-109, 11-8

INSERT/UPDATE, 6-32

integration

BI integration, Transfer Wizard, 22-5

integrators

agent, defined in glossary, 1-2

integrator, defined in glossary, 1-17

software integrators

about, 4-2

Software Library, defined in glossary, 1-34

intersect

in the Set Operation operator, 8-103

Joiner operator, 8-17

full outer joins, 8-22

properties, 8-18

joins

full outer joins in the Joiner operator, 8-22

Key Lookup operator, 8-23

surrogate key, 8-23

keys

cubes, defining foreign key references, 3-68

keywords

for Metadata Loader Export Utility, 15-29

languages

base language, 2-23

base language, defined in glossary, 1-3

setting locale preferences, 2-22

setting the display language, 2-22

launching

Deployment Manager, 13-6

Runtime Audit Browser, client version, 14-2

Runtime Audit Browser, portal version, 14-4

Warehouse Builder, 2-12

levels

child, defined in glossary, 1-5

load column when

deleting row, 6-35

inserting row, 6-39

updating row, 6-35

load column when updating row, 6-39

loading

analytic workspace, 22-26, 22-28, 22-30

conventional path for master-detail targets, sample mapping, 8-40

direct path for master-detail targets, sample mapping, 8-45

master and detail records, 8-36

master-detail relationships, conventional path, 8-37

master-detail relationships, direct path, 8-43

SAP data into the repository, 21-34

loading types, 6-32, 6-40

CHECK/INSERT, 6-33

DELETE, 6-33

DELETE/INSERT, 6-33

for SAP, 21-26

INSERT, 6-32

INSERT/UPDATE, 6-32

TRUNCATE/INSERT, 6-33

UPDATE, 6-32

UPDATE/INSERT, 6-33

locales

setting, in general preferences, 2-22

locations

about, 3-3

connector, defined in glossary, 1-6

creating, 3-4

database link, defined in glossary, 1-8

defining, 3-3

editing, 3-5

viewing location reports, 14-7

locks

folder-in-use locks on objects, 2-15

synchronizing changes to locked objects, 2-16

write locks on objects, 2-15

log file

export to OMG CWM, 22-15

log files, 2-27

export to OMG CWM, 22-13

logical name

requirements, 6-17

logical name mode See business name mode, 2-24

logical names See business names, 2-25

logical records

in flat files, 4-35

logs

message log preferences, 2-26

metadata archive log file, 15-14

Metadata Loader log files, 15-4

metadata restore log file, 15-27

managing

custom Browser reports, 17-26

repositories, Runtime Audit Browser, 14-10

Runtime Audit Browser, 14-9

Mapping Editor

about, 6-3

keyboard operations, A-4

Mapping Flat File operator, about, 8-30

Mapping Input Parameter operator, 8-48

about, 8-48

properties, 8-48

using, 8-48

mapping operators

Advanced Queue operator, 8-26

Aggregator operator, 8-5

Constant operator, 8-9

data flow operator, defined in glossary, 1-7

Data Generator operator, 8-11

Deduplicator operator, 8-14

Expression operator, 8-14

Filter operator, 8-15

Joiner operator, 8-17

Key Lookup operator, 8-23

Mapping Flat File operator, 8-30

Mapping Input Parameter operator, 8-48

Mapping Output Parameter operator, 8-49

Mapping Sequence operator, 8-51

Match-Merge operator, 8-53

Name and Address operator, 8-73

Pivot operator, 8-92

Post-Mapping Process operator, 8-100

Pre-Mapping Process operator, 8-101

Set Operation operator, 8-103

Sorter operator, 8-104

Splitter operator, 8-106

Table Function operator, 8-111

Transformation operator, 8-115

Unpivot operator, 8-117

See also operators

Mapping Output Parameter operator, 8-49

about, 8-49

properties, 8-50

using, 8-50

Mapping Sequence operator, 8-51

extracting from master-detail flat files, 8-34

Mapping Sequence operator with master-detail flat file sources, 8-34

mappings

about, 6-2

compressing, 6-20

configuring, 11-2, 11-20

connecting operators, 6-21

data flow operators, adding, 6-8

defining, 6-1

defining mappings with SAP objects, 21-20

defining, steps for, 6-2

display sets, 6-18

display sets, defining, 6-18

display sets, selecting, 6-20

editing, 6-3

executing, 13-18

flat file sources, 11-13

flat file targets, 11-13

groups, 6-13, 6-14

loading the analytic workspace, 22-28

Mapping Editor, 6-3

mapping, defined in glossary, 1-20

maximum number of errors, 11-6

New Mapping Wizard, 6-2

operators, 6-5

operators, adding, 6-8

operators, connecting, 6-21

PL/SQL mappings, 11-20

prerequisites for advanced queue execution, 8-28

renaming objects in, 6-13

runtime parameters, configuring, 11-4

selecting mappings to execute, 13-18

source operators, adding, 6-10

sources and targets, configuring, 8-111, 11-9

target operators, adding, 6-10

transformations, 8-1

using in process flows, 10-27

master-detail flat files

as sources, about, 8-34

configuring mappings, conventional path load, 8-40

configuring mappings, direct path load, 8-45

Data Generator operator, 8-43

example of a master-detail flat file, 8-34

extracting from, 8-36

extracting from, using conventional path load, 8-37

extracting from, using direct path load, 8-43

importing and sampling, 8-37

operations after initial load, 8-47

performance, 8-37, 8-43

post-update scripts for direct path loads, 8-46

RECNUM, 8-43

sample mapping, conventional path loading, 8-40

sample mapping, direct path loading, 8-45

sequences in target tables, 8-38

Match bins, 8-57

match by constraint, 6-34

match column when

deleting row, 6-40

updating row, 6-35

match column when updating row, 6-39

Match rules, 8-62

active, 8-59

Address rule, 8-64

Conditional rule, 8-66

custom rules, 8-59

Firm rule, 8-68

multiple match rules, 8-62

passive, 8-59

Person rule, 8-69

transitive match rules, 8-63

Weight rule, 8-71

Match-Merge operator, 8-53

concepts, 8-61

custom rules, 8-59, 8-61

design considerations, 8-54, 8-72

editing, 8-55

example, 8-53

groups, 8-56

using, 8-55

materialized views, 3-39

configuring, 5-23

defining, 3-40

editing, 3-43

fast refresh, 5-25

materialized view editor, 3-43

New Materialized View Wizard, 3-40

renaming, 3-43

update definitions, 3-43

mcmview.bat

snapshot comparison reports, 16-19

MDL See Metadata Loader

measures

additive measures, defined in glossary, 1-1

Merge rules, 8-59

custom, 8-61

messages

message log preferences, 2-26

metadata

archiving instructions, 15-12

archiving, about, 15-11

archiving, defined in glossary, 1-3

backup using snapshots, 16-1

backup with the Metadata Loader (MDL), 15-1

change management using snapshots, 16-1

change management with snapshots, 16-18

change management, OMB Plus, 16-2

differences between archive and export, 15-12

differences between restore and import, 15-24

exporting metadata, 15-7

exporting snapshots, 16-17

exporting, using the Transfer Wizard, 22-13

history management, 16-1

implementation reports, 17-32

import and export, overview, 15-1

Import Metadata Wizard, 4-11

import modes, 15-21

importing from databases, 4-11

importing metadata, 15-15

importing snapshots, 16-17

importing, about, 15-15

importing, matching criteria, 15-22

importing, validation rules, 15-16

lineage and impact analysis diagrams, 17-34

lineage and impact analysis reports, 17-33

metadata, defined in glossary, 1-21

restoring, 15-24

restoring instructions, 15-24

restoring snapshots, 16-16

snapshots, about, 16-2

snapshots, objects supported by, 16-2

summary reports, 17-29

metadata history management, 16-1

See also snapshots

Metadata Loader

about, 15-2

access privileges, 15-3

archiving, defined in glossary, 1-3

command line utility, 15-27

creating scripts for, 15-28

exporting metadata in Warehouse Builder client, 15-9

exporting metadata, about, 15-7

importing metadata in Warehouse Builder client, 15-17

importing metadata, about, 15-15

importing metadata, modes, 15-21

importing, validation rules, 15-16

log files, 15-4

metadata matching criteria, 15-22

results, 15-4

snapshots, using with metadata import, 16-21

metadata loader (MDL)

overview of MDL, 15-1

metadata snapshots

cascade snapshot, defined in glossary, 1-5

Microsoft Windows operating systems

flat files residing on, 4-27

minus

in the Set Operation operator, 8-103

mixed levels of aggregation, 3-57

modes

business name mode, 2-24

ending read/write mode, 2-16

logical name mode See business name mode

naming mode, default, 2-25

physical name mode, 2-25

read-only mode, 2-16

read/write mode, 2-16

modules

configuring warehouse modules, 5-10

database source modules, about, 4-6

defining SAP objects, 21-3

flat file modules, about, 4-26

module, defined in glossary, 1-22

process flow modules, 10-2

SAP application, 21-4

source modules, 4-2

multiple user account system, 2-6, 2-9

multiple-record-type flat files

master-detail structure, 8-34

master-detail structure, example of, 8-34

multiple-table insert, 8-109, 11-8

multiple-user access

about, 2-15

ending read/write mode, 2-16

folder-in-use locks, 2-15

read-only mode, 2-16

read/write mode, 2-16

synchronizing changed objects, 2-16

write locks on objects, 2-15

Name Address operator

Primary Country, 8-81

Name and Address operator, 8-73

CASS reporting, 8-90

countries with postal matching, 20-16

enabling, 8-74

example, 8-75

input roles, 20-2

output components, 20-4

properties, Parsing Type, 8-80

using, 8-79

Name-Address operator

Definitions, 8-79

Dual Address Assignment, 8-81

General, 8-79

Groups, 8-82

Input Attributes, 8-83

Output Attributes, 8-85

Output Components, 8-87

Output Components, selecting, 8-85

Parsing Type, 8-80

names

bound name, defined in glossary, 1-4

business name mode, 2-24

business name, defined in glossary, 1-4

business object names, syntax for, 2-25

default naming mode, 2-25

logical name mode See business name mode

physical name mode, 2-25

physical object names, syntax for, 2-25

short name, defined in glossary, 1-33

naming

bound name, defined in glossary, 1-4

business name, defined in glossary, 1-4

business names, maximum length, 6-17

business names, requirements, 6-17

modes, default naming mode, 2-25

objects, business name mode, 2-24

objects, logical name mode See business name mode, 2-24

objects, physical name mode, 2-25

setting naming preferences, 2-23

short name, defined in glossary, 1-33

transformation names, 2-24

navigating

navigation tree folders, 2-18

project navigation tree, 2-17

navigation tree

child, defined in glossary, 1-5

clipboard, defined in glossary, 1-5

collection, defined in glossary, 1-6

connector, defined in glossary, 1-6

console, defined in glossary, 1-7

deploying objects from, 13-5

searching, 2-37

searching for objects, 2-37

New Cube Wizard, 3-67

New Mapping Wizard, 6-2

New Transformation Wizard, 9-6

no cascade snapshots

about, 16-3

no cascade, full snapshots, 16-4

no cascade, signature snapshots, 16-4

non-Oracle database systems

as data sources, 4-4

connecting, 4-6

normalization

denormalize, defined in glossary, 1-9

NULLIF

constraint in the Flat File Sample wizard, 4-48

NUMBER, 3-19

objects

binding, defined in glossary, 1-4

bound name, defined in glossary, 1-4

bound object, defined in glossary, 1-4

business name, defined in glossary, 1-4

child, defined in glossary, 1-5

creating, 2-32

database object, defined in glossary, 1-9

defining mappings with SAP objects, 21-20

defining SAP objects, 21-3

deploying, 13-5

deploying from the navigation tree, 13-5

deploying with the Deployment Manager, 13-5

editing, 2-32

executing deployed objects, 13-18

folder-in-use locks, 2-15

invalid objects, editing, 12-7

parent, defined in glossary, 1-26

restoring from snapshots, 16-16

searching the navigation tree, 2-37

selecting for deployment, 13-16

selecting objects to execute, 13-18

short name, defined in glossary, 1-33

supported by metadata snapshots, 16-2

synchronizing changes to locked objects, 2-16

syntax for business names, 2-25

syntax for logical names, 2-25

syntax for physical names, 2-25

using object editors, 2-35

validating, 12-2

write locks, 2-15

ODBC

for heterogeneous data sources, 4-4

OLAP

cube, defined in glossary, 1-7

data mart, defined in glossary, 1-8

data warehouse, defined in glossary, 1-8

OLAP, defined in glossary, 1-23

PL/SQL routines, 22-26

OLAP metadata

creating, 22-18

debugging export, 22-26

deploying, 22-22

exporting with OWB Transfer Wizard, 22-22

loading analytic workspace, 22-26

OLAP see online analytical processing, 22-16

OLAP Server, 22-2

OLE DB drivers

for heterogeneous data sources, 4-4

OMB PLUS, 6-2

OMB Plus

exporting metadata, 15-1

importing metadata, 15-1

metadata change management, 16-2

metadata snapshots, 16-2

online analytical processing, 22-16

opening

Deployment Manager, 13-6

operating modes

row based, 11-5, 11-21

row based (target only), 11-5, 11-22

selecting a default mode, 11-20

set based, 11-5, 11-21

set based fail over to row based, 11-5

set based fail over to row based (target only), 11-5

operating systems

flat files on Windows systems, 4-27

flat files residing on different operating systems, 4-27

UNIX, launching Warehouse Builder, 2-14

Windows, launching Warehouse Builder, 2-12

Operator Editor

about, 6-13

displaying, 6-13

General tab, 6-13

Groups tab, 6-14

Input tab, 6-14

Input/Output tab, 6-14

Output tab, 6-14

operator properties

for flat file operators, 6-40

for source operators, 6-31

for target operators, 6-31

loading types, 6-32, 6-40

types of, 6-29

operators

about, 6-5

adding to a mapping, 6-8

Advanced Queue operator, 8-26

Aggregator operator, 8-5

binding, defined in glossary, 1-4

connecting by attributes, 6-21

connecting by auto mapping, 6-23

connecting by groups, 6-23

connecting in mappings, 6-21

Constant operator, 8-9

data flow operator, defined in glossary, 1-7

data flow operators, adding, 6-8

Data Generator operator, 8-11

Deduplicator operator, 8-14

editor for, 6-13

Expression operator, 8-14

Filter operator, 8-15

inbound reconciliation, 6-41

Joiner operator, 8-17

Key Lookup operator, 8-23

Mapping Flat File operator, 8-30, 11-13

Mapping Input Parameter operator, 8-48

Mapping Output Parameter operator, 8-49

Mapping Sequence operator, 8-51

Match-Merge operator, 8-53

Name and Address operator, 8-73

naming conventions, 6-17

Pivot operator, 8-92

Post-Mapping Process operator, 8-100

Pre-Mapping Process operator, 8-101

properties, 6-29

properties, types of, 6-29

reconciling operators, about, 6-41

renaming, 6-13

row set, defined in glossary, 1-31

Set Operation operator, 8-103

Sorter operator, 8-104

source operators, adding, 6-10

Splitter operator, 8-106

Table Function operator, 8-111

target operators, adding, 6-10

Transformation operator, 8-115

Unpivot operator, 8-117

Oracle Designer 6i, 4-21

Application Systems, 4-22

source module, 4-21

workareas, 4-22

Oracle Heterogeneous Services, 4-4

Oracle Portal, 18-2

Oracle Transparent Gateways, 4-4, 4-6

Oracle Warehouse Builder Name and Address

purchasing license, 8-74

Oracle9i Discoverer, 22-2

Oracle9iAS Portal

about, 18-2

ORDER BY

in the Sorter operator, 8-104

organization

of flat file records, 4-34

orphaned snapshots, 16-17

outbound reconciliation

for operators, 6-45

Output Attributes

Name-Address operator, 8-85

Output Components

Name-Address operator, 8-87

selecting, for the Name-Address operator, 8-85

OWB PUBLIC VIEW ROLE, 2-10

OWB Transfer Wizard

deploying OLAP metadata, 22-22

packages

for process flows, 10-2

Parsing Type

Name-Address operator, 8-80

partition exchange loading

DML, defined in glossary, 1-11

Partition Exchange Loading (PEL), 11-30

about, 11-31

configuring mappings for, 11-31

configuring targets for, 11-36

performance considerations, 11-35

restrictions on, 11-36, 11-40

partition exchange loading (PEL), 11-10

partitions, 5-6

configuring, 5-6, 5-8

PEL See Partition Exchange Loading

performance

loading master-detail relationships, 8-42

warehouse keys, 3-67

physical aspects

cube table, 3-67

dimension table, 3-55

physical names

physical name mode, 2-25

syntax for physical object names, 2-25

Pivot operator

about, 8-92

editing, 8-94

example, 8-92

expressions for, 8-99

groups, 8-95

input attributes, 8-97

output attributes, 8-97

row locators, 8-93, 8-98

using, 8-94

PL/SQL

deploying PL/SQL scripts for transparent tables, 21-38

security plug-in specifications, 19-9

PL/SQL mappings, 11-3, 11-20

design considerations, 11-26

PL/SQL routines, 22-26

WB_OLAP_LOAD_CUBE, 22-27

WB_OLAP_LOAD_DIMENSION, 22-27

plug-ins

PL/SQL security package, interface specification, 19-9

pooled tables, 21-2

portal, launching, 14-4

portlets

about, 18-2

adding, to the Warehouse Builder Browser, 18-6

administration, 18-3

favorites, 17-3

Reports, 18-5

Post-Mapping Process operator, 8-100

preferences

base language, 2-23

choosing the display language, 2-22

clipboard preferences, 2-31

color scheme, 2-21

displaying welcome pages for wizards, 2-21

general Warehouse Builder client preferences, 2-21

locale, 2-22

message log preferences, 2-26

naming preferences, 2-23

recycle bin preferences, 2-31

setting browser preferences, 2-29

setting Warehouse Builder client preferences, 2-20

utilities preferences, 2-28

utilities, adding, 2-28

utilities, removing, 2-29

utilities, updating, 2-29

Pre-Mapping Process operator, 8-101

Primary Country

Name-Address operator, 8-81

primary keys, 3-20

primary source, 6-32

print report, 17-26

printing

Browser reports, 17-26

privileges

object, 2-11

system, 2-11

process flow activities

AND, 10-17

Email, 10-18

End, 10-19

External Process, 10-22

File Exists, 10-24

Fork, 10-24

FTP, 10-25

Mapping, 10-27

OR, 10-28

Start, 10-28

Subprocess, 10-29

Transform, 10-30

Process Flow Editor

about, 10-5

displaying, 10-8

navigating, 10-9

user interface, 10-5, 10-31

process flows

about, 10-1

activities, 10-10

configuring, 11-41

creating, 10-3

editing, 10-5

error handling, 10-19

executing, 13-18

loading the analytic workspace, 22-30

modules, 10-2

packages, 10-2

passing in values, 10-12

Process Flow Editor, 10-5, 10-8

selecting process flows to execute, 13-18

transitions, 10-13

projects

archiving, about, 15-11

archiving, instructions, 15-12

backup with the Metadata Loader (MDL), 15-1

creating, 2-32

project navigation tree, 2-17

project, defined in glossary, 1-28

restoring, 15-24

restoring, instructions, 15-24

searching for objects, 2-37

properties

attribute properties, setting, 6-37

flat file operator properties, setting, 6-40

property sheets, 2-35

source operator properties, setting, 6-31

target operator properties, setting, 6-31

properties inspector

using, 5-10

Properties Windows

displaying, 6-30

for attributes, 6-30

for groups, 6-29

for operators, 6-29

property sheet

cube table, 3-70

dimension, 3-65

object, 3-65

table, 3-66

materialized view, 3-43

read-only mode, 2-16

read/write mode, 2-16

ending read/write mode, 2-16

RECNUM

in extracting from master-detail flat files, 8-43

in the Data Generator operator, 8-11

reconciliation

reconciliation vs. synchronization, 6-41

reconciling operators, about, 6-41

reconciling

advanced queues, 8-27

external table definitions, 3-30

inbound, 6-41

match strategies, 3-32

operators, about, 6-41

outbound, 6-45

reconcile strategies, 3-32

record numbers

in the Data Generator operator, 8-11

records

delimiter, defined in glossary, 1-9

extracting and loading master and detail records, 8-36

relationships between masters and details in flat files, 8-35

recycle bin

preferences, 2-31

reference materials

distributed database systems, 4-6

non-Oracle database systems, 4-6

registering

repositories, Runtime Audit Browser, 14-11

registering a Warehouse Builder user, 2-8

reimporting

advanced queues, 3-51

database definitions, 4-14

relational objects

defining, 3-9

relational online analytical processing, 22-18

relationships

between master and detail records, 8-35

REMAINING_ROWS output group

in the Splitter operator, 8-106

remote function call (RFC), 21-4

RFC connection, 21-8

SAP RFC connection, 21-9

removing

utilities from the utility drawer, 2-29

rename warehouse object

view, 3-38

renaming

indexes, 5-6

materialized views, 3-43

views, 3-38

reordering

table columns, 3-19

reports

accessing, 17-25

accessing from the client, 17-25

accessing from Warehouse Builder Browser, 17-27

adding custom reports to a role, 18-17

creating custom, 18-28

custom reports in Browser, 17-26

detailed dimension, 17-31

detailed fact, 17-30

detailed file, 17-31

detailed function, 17-31

detailed function library, 17-31

detailed installation, 17-31

detailed materialized view, 17-31

detailed module, 17-31

detailed record, 17-31

detailed sequence, 17-31

detailed table, 17-32

detailed transform map, 17-32

detailed view, 17-32

execution reports, 14-8

execution schedule reports, 14-8

execution summary reports, 14-8

implementation, 17-32

lineage and impact analysis, 17-33

lineage and impact analysis diagrams, 17-34

predefined in Warehouse Builder, 17-28

printing, 17-26

project, 17-31

registering custom, 18-15

runtime audit reports, 14-15

snapshot comparison reports, generating, 16-19

summary, 17-29

trace reports, 14-9

viewing custom Browser reports, 17-26

viewing custom reports, 17-26

viewing deployment reports, 14-6

viewing location reports, 14-7

viewing Runtime Repository reports, 14-6

Reports Portlet, 18-5

Reports Tab, 17-14

repositories

backup with the Metadata Loader (MDL), 15-1

design repository, defined in glossary, 1-10

editing repository information, Runtime Audit Browser, 14-11

managing access, Runtime Audit Browser, 14-10

registering, Runtime Audit Browser, 14-11

Runtime Audit Browser administration, 14-10

unregistering, in Runtime Audit Browser, 14-10

requirements

for business names, 2-25

reserved words, B-1

restoring

differences between restore and import, 15-24

metadata, 15-24

objects from snapshots, 16-16

parents of orphaned snapshots, 16-17

projects, 15-24

projects, instructions, 15-24

snapshots, 16-16

ROLAP see relational online analytical processing, 22-18

roles

adding custom reports, 18-17

administration, Runtime Audit Browser, 14-13

root snapshots

altering, 16-16

deleting non-root snapshots, 16-16

row based, 11-5, 11-21

row based (target only), 11-5, 11-22

row locators

in the Pivot operator, 8-93, 8-98

in the Unpivot operator, 8-118, 8-120

row sets

definition of, 1-31

rows

column, defined in glossary, 1-6

definition of, 1-31

RTRIM

in the Transformation operator, 8-116

rules

dimension object, 3-55

runtime

maximum number of errors, 11-6

Runtime Audit Browser

administration, 14-9

administrator list, 14-14

auditing deployment and execution, 14-2

available reports, 14-15

client, launching, 14-2

database links, 14-11

editing repository information, 14-11

execution reports, 14-8

execution summary reports, 14-8

integrated with Oracle9iAS, launching, 14-4

managing access to repositories, 14-10

registering repositories, 14-11

roles, administration, 14-13

trace reports, 14-9

viewing deployment reports, 14-6

viewing execution reports, 14-7

viewing location reports, 14-7

viewing reports, 14-6

Runtime Platform Service, about, 1-4

Runtime Repository

defining connections, 13-2

deployment information, 13-1

viewing deployment reports, 14-6

viewing reports, 14-6

runtime, SAP, 21-29

sampling

flat files, 4-32

master-detail flat files, 8-37

SAP

ABAP, defined in glossary, 1-1

configuring SAP file physical properties, 21-26

defining ETL process for SAP objects, 21-20

defining mappings with SAP objects, 21-20

defining SAP objects, 21-3

loading SAP data into the repository, 21-34

SAP ABAP Editor, 21-35

upload command, 21-36

SAP application

source module, 21-4

SAP Business Areas

about, 21-2

SAP file physical properties

Control File Name, 21-30

Data File Name, 21-29

File Delimiter for Staging File, 21-30

Log File Name, 21-30

Nested Loop, 21-30

SAP System Version, 21-29

Sequel Join Collapsing, 21-30

Staging File Directory, 21-29

Use Internal Table for Lookup only Table, 21-30

Use Single Select, 21-30

SAP File System Deployment dialog, 21-34

SAP Import From a Local File dialog, 21-36

SAP Integrator

about, 21-2

creating definitions, 21-4

objects supported, 21-16

required files, 21-5

SAP parameters

generation target directories, 21-30

loading type, 21-26

runtime, 21-29

step type, 21-27

SAP remote function call (SAPRFC.INI), 21-4

SAP table types

cluster, 21-2

importing, 21-2

pooled, 21-2

transparent, 21-2

SAPRFC.INI file, 21-5, 21-9

saving

deployment scripts, 13-18

schemas

schema, defined in glossary, 1-32

snowflake schema, defined in glossary, 1-34

star schema, defined in glossary, 1-34

scripting

See also Oracle 9i Warehouse Builder Software Development Kit Reference

See OMB PLUS

scripts

generating, about, 12-7

saving deployment scripts, 13-18

searching

for objects in a project, 2-37

navigation tree, 2-37

second class objects (SCOs)

glossary definition, 1-32

security

ending read/write mode, 2-16

EXECUTE ALL PROCEDURES, 2-12

folder-in-use locks on objects, 2-15

multiple user account system, 2-6

multiple-user access, 2-15

OWB PUBLIC VIEW ROLE, 2-10

PL/SQL package interface, 2-10

privileges, 2-11

read-only mode, 2-16

read/write mode, 2-16

registering a Warehouse Builder user, 2-8

requirements, 2-12

security registration service, 2-6

synchronizing changes to locked objects, 2-16

write locks on objects, 2-15

security registration service, 2-6, 2-10

selecting

objects for deployment, 13-16

objects to execute, 13-18

SEQUENCE

in the Data Generator operator, 8-12

sequences, 3-44

configuring, 5-26

defining, 3-44

editing, 3-45

for master-detail targets, 8-38

New Sequence Wizard, 3-44

sequence, defined in glossary, 1-32

server

client, defined in glossary, 1-5

servers

database server, defined in glossary, 1-9

services

heterogeneous services, 4-6

set based, 11-5, 11-21

set based fail over to row based, 11-5

set based fail over to row based (target only), 11-5

Set Operation operator, 8-103

intersect, 8-103

minus, 8-103

union, 8-103

union all, 8-103

setting

browser preferences, 2-29

clipboard preferences, 2-31

color scheme preferences, 2-21

display language preferences, 2-22

locale preferences, 2-22

message log preferences, 2-26

naming preferences, 2-23

recycle bin preferences, 2-31

utilities preferences, 2-28

Warehouse Builder client preferences, 2-20

wizard preferences, 2-21

Setting the Generation Target Directories, 21-30

Setting the Runtime Parameter, 21-29

Setting the Step Type Parameter, 21-27

short name

defining, 1-33

reserved words, B-1

signature snapshots

about, 16-3

signature, cascade snapshots, 16-4

signature, no cascade snapshots, 16-4

snapshots

altering metadata snapshots, 16-16

backing up metadata with snapshots, 16-1

cascading, about, 16-3

change management, 16-18

comparison reports, 16-18

comparison reports, generating, 16-19

converting full to signature, 16-3

deleting non-root snapshots, 16-16

deployment, using during, 16-21

exporting snapshots, 16-17

full snapshots, 16-3

full to signature, converting, 16-3

full/signature, about, 16-3

history management, 16-15

impact analysis, using with, 16-21

importing snapshots, 16-17

MDL metadata import, using with, 16-21

metadata snapshots, about, 16-2

no cascade snapshots, 16-3

orphaned snapshots, 16-17

restoring, 16-16

signature snapshots, 16-3

supported objects, 16-2

type combinations, 16-4

usage suggestions, 16-21

snowflakes

snowflake schema, defined in glossary, 1-34

software integrators

about, 4-2

Oracle Transparent Gateways, 4-4

sorted indexes, 11-12

Sorter operator, 8-104

ORDER BY, 8-104

source data

cleansing, defined in glossary, 1-5

data source, defined in glossary, 1-8

source locations, Deployment Manager, 13-8

source module

connection information

SAP source, 21-7

SAP application, 21-4

source modules, 4-1

connection information, 4-5

creating, 4-2

database links, 4-5

defining SAP objects, 21-3

flat files, 4-29

importing definitions, 4-11

Oracle Designer 6i, 4-22

Oracle Designer Repository, 4-21

source operators

primary source, 6-32

properties, 6-31

sources

cleansing, defined in glossary, 1-5

data source, defined in glossary, 1-8

data sources, 4-1

database source modules, about, 4-6

database, defined in glossary, 1-8

defining SAP objects, 21-3

delimited flat file, defined in glossary, 1-9

flat file source operators, about, 8-30

flat file source operators, importing/binding, 8-32

flat file source operators, previously imported, 8-32

flat file sources, about, 4-29

master-detail flat file sources, 8-34

master-detail flat files, 8-34

master-detail flat files, example, 8-34

module, defined in glossary, 1-22

source, defined in glossary, 1-34

updating source definitions, 4-19

Splitter operator, 8-106

REMAINING_ROWS output group, 8-106

SQL properties

for flat files, 4-48

SQL*Loader

datatypes, 4-47

parameters, 6-33

properties for flat files, 4-47

starting

Warehouse Builder, 2-12

step type, SAP, 21-27

summarizing

data with a transformation, 8-5

surrogate keys

in the Key Lookup operator, 8-23

See also primary keys

synchronization

synchronization vs. reconciliation, 6-41

synchronizing

automatic synchronization, 2-17

changes to objects, 2-16

on command, 2-17

syntax

for business object names, 2-25

for logical object names, 2-25

for physical object names, 2-25

SYSDATE

in the Data Generator operator, 8-12

table editor, 3-14

Table Function operator, 8-111

prerequisites, 8-112

using, 8-115

table functions, 11-7

table properties

dimension table, 3-65

tables, 3-11

adding columns, 3-17

column, defined in glossary, 1-6

columns, 3-13, 3-17

configuring, 5-13

constraint, defined in glossary, 1-7

constraints, 3-14

cube, defined in glossary, 1-7

data types, 3-18

database link, defined in glossary, 1-8

defining, 3-11

defining cubes, 3-67

denormalize, defined in glossary, 1-9

deploying PL/SQL scripts for transparent tables, 21-38

derived fact (or measure), defined in glossary, 1-10

dimension, defined in glossary, 1-10

editing, 3-14, 3-16

length, 3-18

naming, 3-12

New Cube Wizard, 3-67

New Table Wizard, 3-11

precision, 3-18

related tables, 3-15

renaming, 3-16

reordering columns, 3-19

reports, 3-15

row set, defined in glossary, 1-31

row, defined in glossary, 1-31

scale, 3-18

table, defined in glossary, 1-36

tabs

reports, 17-14

target operators

properties, 6-31

target systems

deploying and updating, 13-2

targets

database, defined in glossary, 1-8

delimited flat file, defined in glossary, 1-9

flat file operators, inserting new, unbound, 8-33

flat file target operators, about, 8-30

flat file target operators, importing/binding, 8-32

flat file target operators, multiple record types, 8-32

flat file target operators, previously imported, 8-32

flat file targets, about, 4-29

module, defined in glossary, 1-22

multiple targets in a mapping, 11-23

multiple targets in mappings, 8-106, 8-109, 11-8

sequences for master-detail target tables, 8-38

target, defined in glossary, 1-37

terms

glossary, 1-1

time dimensions

creating, 3-66

toolbars

commit, 2-15

Deployment Manager toolbar, 13-11

horizontal toolbar in Warehouse Builder console, 2-18

property icon, 2-35

transactions

commit, defined in glossary, 1-6

Transfer Wizard

about, 22-5

bridge, defined in glossary, 1-4

CWM, defined in glossary, 1-6

log file

export, 22-15

log file, export, 22-13

version, 22-9

transformation

create definition, 9-6

custom example, 9-6

filter data, 9-6

Transformation operator, 8-115

CHAR, 8-116

CHAR result RTRIM, 8-116

data type, 8-116

RTRIM, 8-116

transformations, 8-1

group by operation, 8-5

names, unique, 2-24

Transformation Library, defined in glossary, 1-38

transformation, defined in glossary, 1-38

transitions, 10-15

about, 10-13

conditional transitions, 10-13

transparent

agents, 4-6

transparent tables, 21-2

tree

deploying objects from the navigation tree, 13-5

deployment tree, 13-7

trees

project navigation tree, 2-17

TRUNCATE/INSERT, 6-33

union

in the Set Operation operator, 8-103

union all

in the Set Operation operator, 8-103

unique

transformation names, 2-24

unique key

constraint on levels, 3-56

unique keys, 3-20

Universal Object Identifiers

and Metadata Loader, 15-22

UNIX operating systems

launching Warehouse Builder, 2-14

Unpivot operator

about, 8-117

editing, 8-118

example, 8-117

expressions for, 8-123

groups, 8-119

input attributes, 8-120

input connections, 8-119

output attributes, 8-122

row locators, 8-118, 8-120

using, 8-118

UOIDs See Universal Object Identifiers

UPDATE, 6-32

update (operation), 6-39

target conditions, 6-39

update definition

view, 3-38

UPDATE/INSERT, 6-33

updating

connection information, data sources, 4-20

flat file definitions, 4-49

source definitions, 4-19

target systems, 13-2

utilities, 2-29

updating SAP object definitions, 21-19

user interface

navigation tree folders, 2-18

project navigation tree, 2-17

Warehouse Builder console, 2-17

User's Guide

glossary of terms, 1-1

utilities

adding, to the utility drawer, 2-28

mcmview.bat, 16-19

Metadata Loader command line utility, 15-27

removing, from the utility drawer, 2-29

setting utilities preferences, 2-28

snapshot comparison reports, 16-19

updating utilities, 2-29

utility drawer

adding utilities, 2-28

removing utilities, 2-29

validating

about, 12-1

Deployment Manager, defined in glossary, 1-10

editing invalid objects, 12-7

objects, 12-2

validation

about, 12-1

editing invalid objects, 12-7

message editor, 12-6

object editor, 12-6

results, 12-2

results, evaluating, 12-3

Validation Results Dialog, 12-3

validation, defined in glossary, 1-39

viewing details, 12-6

VARCHAR, 3-19

VARCHAR2, 3-19

version, Warehouse Builder, 21-3

versions

archiving projects, 15-12

bridges, 22-9

Transfer Wizard, 22-9

viewing

custom Browser reports, 17-26

custom reports, 17-26

deployment history, 13-17

views, 3-34

defining, 3-35

editing, 3-38

New View Wizard, 3-35

renaming, 3-38

Warehouse Builder

about Warehouse Builder, 1-1

benefits, 1-7

components, 1-4

console, 2-17

glossary of terms, 1-1

launching Warehouse Builder, 2-12

predefined reports, 17-28

project navigation tree, 2-17

setting client preferences, 2-20

starting Warehouse Builder, 2-12

user interface, 2-17

Warehouse Builder Browser

adding custom reports to a role, 18-17

administration, 18-9

administration portlet, 18-3

browsing the favorites, 17-19

contents tab, 17-12

creating custom reports, 18-28

creating database links, 18-12

current item information, 17-11

customizing favorites, 17-22

dropping database links, 18-14

editing database links, 18-13

implementation reports, 17-32

lineage and impact analysis diagrams, 17-34

lineage and impact analysis reports, 17-33

portlets, adding, 18-6

QA user role, 18-19

registering a custom report, 18-10, 18-15

registering a repository, 18-10

related tab, 17-13

reports tab, 17-14

reports, accessing, 17-27

roles, 18-19

setting preferences, 2-29

summary reports, 17-29

unregistering a repository, 18-15

viewing database links, 18-13

warehouse developer role, 18-19

warehouse user role, 18-19

warehouse keys

column, 3-63

performance, 3-67

warehouse modules

configuring, 5-10

renaming materialized views, 3-43

renaming views, 3-38

warehouse objects

renaming materialized views, 3-43

renaming views, 3-38

WB_OLAP_LOAD_CUBE, 22-27

WB_OLAP_LOAD_DIMENSION, 22-27

WHERE

in the Filter operator, 8-15

Windows operating systems

launching Warehouse Builder, 2-12

wizards

Archive Wizard, 15-12

External Table Wizard, 3-27

Flat File Sample Wizard, 4-32

Import Metadata Wizard, 4-11, 4-30

Match-Merge Wizard, 8-55

New Collection Wizard, 22-3

New Cube Wizard, 3-67

New Dimension Wizard, 3-58

New External Table Wizard, 3-27

New Mapping Wizard, 6-2

New Materialized View Wizard, 3-40

New Sequence Wizard, 3-44

New Table Wizard, 3-11

New Transformation Wizard, 9-6

New View Wizard, 3-35

Pivot Wizard, 8-94

Restore Wizard, 15-24

Transfer Wizard, 22-5

Unpivot Wizard, 8-118

using Warehouse Builder wizards, 2-34

welcome pages, displaying, 2-21

workareas

Designer 6i, 4-21

Workflow Management Consortium (WfMC), 10-2

write locks

on objects, 2-15

XML

XML Process Definition Language(XPDL), 10-2

ZONED, 4-47