Index

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

A

ABAP

ABAP, defined in glossary, Glossary

directory storing scripts, 21.3.2.4

extension for scripts, 21.3.2.4

run parameter file, 21.3.2.4

scripts, buffer directory, 21.3.2.4

scripts, directory, 21.3.2.4

scripts, extension, 21.3.2.4

scripts, generating, 21.3.2.2

spool directory, 21.3.2.4

access

ending read/write mode, 2.4.1

folder-in-use locks, 2.4

managing access to repositories, Runtime Audit Browser, 14.4.1

multiple-user access, about, 2.4

read-only mode, 2.4.2

read/write mode, 2.4.1

write locks on objects, 2.4

access parameters

for external tables, 3.4.5.1

access specifications

for external tables, 5.5.1

activities

about, 10.3.2

adding to process flows, 10.3.2.1

AND, 10.3.4.1

binding to parameters, 10.3.2.2

connecting, 10.3.3.1

Email, 10.3.4.2

End, 10.3.4.3

External Process, 10.3.4.4

File Exists, 10.3.4.5

Fork, 10.3.4.6

FTP, 10.3.4.7

list of, 10.3.4

Mapping, 10.3.4.8

OR, 10.3.4.9

parameters, 10.3.2.1

passing in values, 10.3.2.2

Start, 10.3.4.10

Subprocess, 10.3.4.11

Transform, 10.3.4.12

adding

attribute sets, 3.3.9

attributes to mappings, 6.4

custom reports to a role, 18.3.2.1

data flow operators to mappings, 6.3, 6.3

database links, Runtime Audit Browser, 14.4.1

groups to mappings, 6.4

metadata, 15.4

operators to mappings, 6.3

portlets to the Warehouse Builder Browser, 18.2

source operators to mappings, 6.3.1

table columns, 3.3.5

target operators to mappings, 6.3.1

utilities to the utility drawer, 2.6.4.1

administration

portlet, 18.1.2.2

roles, Runtime Audit Browser, 14.4.2

Runtime Audit Browser, 14.4

administrator list

maintaining, Runtime Audit Browser, 14.4.3

advanced attribute set properties, 3.3.9

Advanced Queue operator, 8.10

example, 8.10.1.1

prerequisites for mapping execution, 8.10.3

properties, 8.10.2

reconciling advanced queues, 8.10.1.2

using, 8.10.1

advanced queues, 3.8

about, 3.8, 3.8.1

Advanced Queue operator properties, 8.10.2

advanced queue, defined in glossary, Glossary

configuring, 5.6

creating, 8.10.1

example, 8.10.1.1

importing, 3.8.2

messages, 3.8.1.2

payload, 3.8.1.1

prerequisites for mapping execution, 8.10.3

properties, 3.8.4

reconciling, 8.10.1.2

reimporting, 3.8.3

B

backup

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

metadata change management using snapshots, 16

backups

archive metadata, defined in glossary, Glossary

base language

base language, defined in glossary, Glossary

setting, 2.6.1

binding

flat file source operators, 8.11.4

flat file target operators, 8.11.4

in process flows, 10.3.2.2

bitmap indexes

impact report for bitmap index creation, 5.1.3

bound

operators, about, 6.3

bound names, 6.4.1.2, 6.6.1.1

bridges

bridge, defined in glossary, Glossary

versions, 22.3.2

bulk processing, 11.1.2.5, 11.1.3.1

bulk size, 11.1.2.2, 11.1.2.5

business intelligence, 22.4

Business Intelligence tools

integration, Transfer Wizard, 22.3

business names

business name mode, 2.6.2.1.1

maximum length, 2.6.2.1.1, 6.4.1.2

requirements, 2.6.2.1.1, 6.4.1.2

syntax for business object names, 2.6.2.1.1, 2.6.2.1.1

C

CASS reporting

about, 8.16.4

restrictions, 8.16.4.2

change management

about metadata snapshots, 16.1

D

Data Definition Language (DDL)

DDL, defined in glossary, Glossary

data definition language (DDL)

configuring partitions

data flow operators

data flow operator, defined in glossary, Glossary

Data Generator operator, 8.4

for extracting from master-detail flat files, 8.11.6.4

RECNUM, 8.4.1

SEQUENCE, 8.4.3

SYSDATE, 8.4.2

using, 8.4.3

Data Manipulation Language (DML)

DML, defined in glossary, Glossary

data manipulation language (DML)

DML, defined in glossary, Glossary

data marts

data mart, defined in glossary, Glossary

data movements

DML, defined in glossary, Glossary

data quality

Match-Merge operator, 8.15

data sources, 4

cleansing, defined in glossary, Glossary

data source, defined in glossary, Glossary

defining SAP objects, 21.2

Oracle Designer 6i, 4.3

Oracle Heterogeneous Services, 4.1.2

Oracle Transparent Gateways, 4.1.2

E

editing

attributes in mappings, 6.4

collections, 22.2.2

connectors, 3.1.2.2

constraints, 3.3.7

cubes, 3.10.2

dimensions, 3.9.3, 3.9.3

groups, 6.4

invalid objects, 12.4

locations, 3.1.1.2

mappings, 6.2.1

materialized views, 3.6.3

objects, 2.7

operators, 6.4

process flows, 10.3

repository information in Runtime Audit Browser, 14.4.1

Runtime Repository connections, 13.2.1.2

sequences, 3.7.3

tables, 3.3.2, 3.3.3

using object editors, 2.7.3

views, 3.5.3

editor

dimension, 3.9.3

materialized view editor, 3.6.3

editors

object editors, using, 2.7.3

endian, 5.5.4

ETL See Extraction Transform and Load

EXECUTE ALL PROCEDURES, 2.2.3

executing

auditing execution, 14

auditing with Runtime Audit Browser, 14.2

deployed objects, 13.7

deployment, defined in glossary, Glossary

mappings, 13.7

process flows, 13.7

selecting objects to execute, 13.7.1

viewing execution reports, 14.3.2, 14.3.2.3

viewing execution schedule reports, 14.3.2.1

viewing execution summary reports, 14.3.2.2

viewing trace reports, 14.3.2.4

export

log file, 22.3.3

exporting

bridge, defined in glossary, Glossary

differences between archive and export, 15.3.5.2

log file, 22.3.2

metadata in Warehouse Builder client, 15.3.3

metadata snapshots, 16.9.1.5

metadata using bridges, 22.3.3

metadata using the Transfer Wizard, 22.3.3

metadata, about, 15.3

metadata, at the command line, 15.5.2

Expression operator, 8.6

external tables

about, 3.4.1

access parameters, 3.4.5.1

access specifications for, 5.5.1

configuring, 5.5

creating, 3.4.2

editing, 3.4.5

editor, 3.4.3

External Table Wizard, 3.4.2

properties, 5.5

reconciling, 3.4.4

trimming settings, 5.5.5

using, 3.4

versus flat file operators, 3.4.1.1

versus SQL*Loader, 3.4.1.1

Extract Transform and Load (ETL), 6

extracting

cleansing, defined in glossary, Glossary

data source, defined in glossary, Glossary

from master-detail flat files, 8.11.6, 8.11.6.2

F

facts

additive facts, defined in glossary, Glossary

facts See cubes

fast refresh, 5.9.2

favorites

filtering Browser favorites, 17.2.3.2

portlets, 17.1.2

FCO

See first class objects (FCOs)

fields

delimiter, defined in glossary, Glossary

Filter operator, 8.7

WHERE, 8.7

filters

favorites, 17.2.3.2

filtering data with a transform, 9.3

Find

finding objects, 2.7.6

finding

objects by searching the navigation tree, 2.7.6

objects in a project, 2.7.6

first class objects (FCOs)

about, 1.1.5

glossary definition, Glossary

Flat File Sample Wizard, 4.5.2

describing the flat file, 4.5.3

field properties, 4.5.9

file format, 4.5.6

file layout, 4.5.5

fixed length flat files, 4.5.8

multiple-record-type files, 4.5.7

record organization, 4.5.4

using, 4.5.2

flat files

about flat file modules, 4.4

as sources and targets, 4.5

character sets, 4.5.3

configuring flat file properties, 11.1.5

configuring flat file targets, 11.1.6

configuring master-detail mappings, conventional path load, 8.11.6.2

configuring master-detail mappings, direct path load, 8.11.6.4

delimited, 4.5.6

delimited flat file, defined in glossary, Glossary

delimiter, defined in glossary, Glossary

enclosures, 4.5.6

extracting master and detail records, 8.11.6.2

field delimiters, 4.5.6

field properties, 4.5.9

fixed length, 4.5.8

Import Metadata Wizard, 4.5.1

importing, 4.5.1

importing master-detail flat files, 8.11.6.2

logical records in, 4.5.4.1

mapping sources, 11.1.5

mapping targets, 11.1.5

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

master-detail, example, 8.11.6

master-detail, extracting from, 8.11.6

master-detail, operations after initial load, 8.11.6.5

multiple record types in, 4.5.7

record delimiters, 4.5.4

residing on different operating systems, 4.4

sampling, 4.5.2

source operators, about, 8.11.1

source operators, importing/binding, 8.11.4

source operators, previously imported, 8.11.3

SQL properties, 4.5.9.2

SQL*Loader datatypes, 4.5.9.1.2

SQL*Loader properties, 4.5.9.1

target operators, about, 8.11.1

target operators, importing/binding, 8.11.4

target operators, inserting new, unbound, 8.11.5

target operators, multiple record types, 8.11.2

target operators, previously imported, 8.11.3

updating formats for, 4.5.10

FLOAT, 3.3.5.1

Folder Dialog, 21.2.2.2

folder-in-use locks

on objects, 2.4

folders

folder-in-use locks, 2.4

project navigation tree, 2.5.1

foreign keys, 3.3.7

defining, for cubes, 3.10.1

full outer joins

in the Joiner operator, 8.8.3

full snapshots

about, 16.2.1, 16.2.2

converting to signature snapshots, 16.2.1

full, cascade snapshots, 16.2.3, 16.2.3

full, no cascade snapshots, 16.2.3, 16.2.3

G

gateways

transparent, 4.1.3

generated code

viewing SAP code, 21.3.3

generating

about, 12.5

code generation, defined in glossary, Glossary

configuring SAP file physical properties, 21.3.2

snapshot comparison reports, 16.9.2.3

generation

about, 12.5

Generation Mode dialog, SAP, 21.3.3

generation target directories, SAP, 21.3.2.4

glossary of terms, Glossary

GROUP BY

in the Aggregator operator, 8.2

Groups

Name-Address operator, 8.16.3.3

groups

adding to mappings, 6.4

connecting by name, 6.5.2.5

connecting by position, 6.5.2.4

connecting in mappings, 6.5.2

directions in, 6.4

editing in mappings, 6.4

naming conventions, 6.4.1.1

properties, 6.6

removing from mappings, 6.4

renaming, 6.4

H

HAVING

in the Aggregator operator, 8.2

heterogeneous data sources, 4.1.2

heterogeneous sources, 4.1.3

hiding

welcome pages for wizards, 2.6.1

hierarchies

child, defined in glossary, Glossary

create definition, 3.9.2

dimension, 3.9.2

hierarchy, defined in glossary, Glossary

hints, 11.1.4.5

history

about metadata snapshots, 16.1

Deployment Manager History tab, 13.3.2.3

See metadata history management

viewing deployment history, 13.5.1

history management

about metadata snapshots, 16.1

using metadata snapshots, 16.9.1

householding, 8.15, 8.15.5

Match-Merge operator, 8.15

I

ID column

rename as warehouse key column, 3.9.2

impact analysis

metadata snapshots, using with, 16.10.1

impact report for bitmap index creation dialog, 5.1.3

importing

advanced queues, 3.8.2

and binding flat file source operators, 8.11.4

and binding flat file target operators, 8.11.4

definitions, database systems, 4.2.2

differences between restore and import, 15.4.5.1

flat files, 4.5.1

Import Metadata Wizard, 4.2.2

Import Metadata Wizard, using, 4.5.1

Import Results dialog, 21.2.2.2

master-detail flat files, 8.11.6.2

metadata import modes, 15.4.4.1

metadata in Warehouse Builder client, 15.4.4

metadata matching criteria, 15.4.4.2

metadata snapshots, 16.9.1.5

metadata, about, 15.4, 15.4

metadata, at the command line, 15.5.3

metadata, validation rules, 15.4.3

Oracle database metadata, 4.2.2

reimporting database definitions, 4.2.3

using snapshots with importing metadata, 16.10.1

importing metadata, 22.3.2

inbound reconciliation

for operators, 6.7.1

independent commit, 11.2.2.1

indexes

bitmap index, defined in glossary, Glossary

bitmap indexes, 5.1.3

configuring, 5.1.4

creating, 5.1.2

renaming, 5.1.5

INI file for SAP Integrator, 21.2.1

Input Attributes

Name-Address operator, 8.16.3.5

INSERT, 6.6.1.3

inserting

flat file target operators, new, unbound, 8.11.5

into multiple targets, 8.22.1, 11.1.3.5, 11.1.3.5

INSERT/UPDATE, 6.6.1.3

integration

BI integration, Transfer Wizard, 22.3

integrators

agent, defined in glossary, Glossary

integrator, defined in glossary, Glossary

software integrators

about, 4.1

Software Library, defined in glossary, Glossary

intersect

in the Set Operation operator, 8.20

J

Joiner operator, 8.8

full outer joins, 8.8.3

properties, 8.8

joins

full outer joins in the Joiner operator, 8.8.3

K

Key Lookup operator, 8.9

surrogate key, 8.9

keys

cubes, defining foreign key references, 3.10.1

keywords

for Metadata Loader Export Utility, 15.5.2.1

L

languages

base language, 2.6.1

base language, defined in glossary, Glossary

setting locale preferences, 2.6.1

setting the display language, 2.6.1

launching

Deployment Manager, 13.3.1

Runtime Audit Browser, client version, 14.2.1

Runtime Audit Browser, portal version, 14.2.2

Warehouse Builder, 2.3

levels

child, defined in glossary, Glossary

load column when

deleting row, 6.6.1.7

inserting row, 6.6.2.6

updating row, 6.6.1.7

load column when updating row, 6.6.2.7

analytic workspace, 22.5.4, 22.5.4.1, 22.5.4.2

conventional path for master-detail targets, sample mapping, 8.11.6.2

direct path for master-detail targets, sample mapping, 8.11.6.4

master and detail records, 8.11.6.2

master-detail relationships, conventional path, 8.11.6.2

master-detail relationships, direct path, 8.11.6.4

SAP data into the repository, 21.4

loading types, 6.6.1.3, 6.6.3.1

CHECK/INSERT, 6.6.1.3

DELETE, 6.6.1.3

DELETE/INSERT, 6.6.1.3

for SAP, 21.3.2.1

INSERT, 6.6.1.3

INSERT/UPDATE, 6.6.1.3

TRUNCATE/INSERT, 6.6.1.3

UPDATE, 6.6.1.3

UPDATE/INSERT, 6.6.1.3

locales

setting, in general preferences, 2.6.1

locations

about, 3.1.1

connector, defined in glossary, Glossary

creating, 3.1.1.1

database link, defined in glossary, Glossary

defining, 3.1.1

editing, 3.1.1.2

viewing location reports, 14.3.1.3

locks

folder-in-use locks on objects, 2.4

synchronizing changes to locked objects, 2.4.3

write locks on objects, 2.4

log file

export to OMG CWM, 22.3.3

log files, 2.6.3

export to OMG CWM, 22.3.2

logical name

requirements, 6.4.1.2

logical name mode See business name mode

logical names See business names, 2.6.2.1.1

logical records

in flat files, 4.5.4.1

logs

message log preferences, 2.6.3

metadata archive log file, 15.3.5.3

Metadata Loader log files, 15.2.2

metadata restore log file, 15.4.5.2

M

managing

custom Browser reports, 17.3.1.1

repositories, Runtime Audit Browser, 14.4.1

Runtime Audit Browser, 14.4

Mapping Editor

about, 6.2.1

keyboard operations, A.5

Mapping Flat File operator, about, 8.11

Mapping Input Parameter operator, 8.12

about, 8.12

properties, 8.12

using, 8.12

mapping operators

Advanced Queue operator, 8.10

Aggregator operator, 8.2

Constant operator, 8.3

data flow operator, defined in glossary, Glossary

Data Generator operator, 8.4

Deduplicator operator, 8.5

Expression operator, 8.6

Filter operator, 8.7

Joiner operator, 8.8

Key Lookup operator, 8.9

Mapping Flat File operator, 8.11

Mapping Input Parameter operator, 8.12

Mapping Output Parameter operator, 8.13

Mapping Sequence operator, 8.14

Match-Merge operator, 8.15

Name and Address operator, 8.16

Pivot operator, 8.17

Post-Mapping Process operator, 8.18

Pre-Mapping Process operator, 8.19

Set Operation operator, 8.20

Sorter operator, 8.21

Splitter operator, 8.22

Table Function operator, 8.23

Transformation operator, 8.24

Unpivot operator, 8.25

N

Name Address operator

Primary Country, 8.16.3.2.2

Name and Address operator, 8.16

CASS reporting, 8.16.4

countries with postal matching, 20.3

enabling, 8.16.1

example, 8.16.2

input roles, 20.1

output components, 20.2

properties, Parsing Type, 8.16.3.2.1

using, 8.16.3

Name-Address operator

Definitions, 8.16.3.2

Dual Address Assignment, 8.16.3.2.3

General, 8.16.3.1

Groups, 8.16.3.3

Input Attributes, 8.16.3.5

Output Attributes, 8.16.3.6

Output Components, 8.16.3.6.1

Output Components, selecting, 8.16.3.6

Parsing Type, 8.16.3.2.1

names

bound name, defined in glossary, Glossary

business name mode, 2.6.2.1.1

business name, defined in glossary, Glossary

business object names, syntax for, 2.6.2.1.1, 2.6.2.1.1

default naming mode, 2.6.2.2

logical name mode See business name mode

physical name mode, 2.6.2.1.2

physical object names, syntax for, 2.6.2.1.2

short name, defined in glossary, Glossary

naming

bound name, defined in glossary, Glossary

business name, defined in glossary, Glossary

business names, maximum length, 6.4.1.2

business names, requirements, 6.4.1.2

modes, default naming mode, 2.6.2.2

objects, business name mode, 2.6.2.1.1

objects, logical name mode See business name mode

objects, physical name mode, 2.6.2.1.2

setting naming preferences, 2.6.2

short name, defined in glossary, Glossary

transformation names, 2.6.2.1

navigating

navigation tree folders, 2.5.1

project navigation tree, 2.5.1

navigation tree

child, defined in glossary, Glossary

clipboard, defined in glossary, Glossary

collection, defined in glossary, Glossary

connector, defined in glossary, Glossary

console, defined in glossary, Glossary

deploying objects from, 13.2.2

searching, 2.7.6

searching for objects, 2.7.6

New Cube Wizard, 3.10.1

New Mapping Wizard, 6.2

New Transformation Wizard, 9.3

no cascade snapshots

about, 16.2.2

no cascade, full snapshots, 16.2.3

no cascade, signature snapshots, 16.2.3

non-Oracle database systems

as data sources, 4.1.2

connecting, 4.1.3

normalization

denormalize, defined in glossary, Glossary

NULLIF

constraint in the Flat File Sample wizard, 4.5.9.1.4

NUMBER, 3.3.5.1

O

objects

binding, defined in glossary, Glossary

bound name, defined in glossary, Glossary

bound object, defined in glossary, Glossary

business name, defined in glossary, Glossary

child, defined in glossary, Glossary

creating, 2.7

database object, defined in glossary, Glossary

defining mappings with SAP objects, 21.3.1

defining SAP objects, 21.2

deploying, 13.2.2

deploying from the navigation tree, 13.2.2

deploying with the Deployment Manager, 13.2.2

editing, 2.7

executing deployed objects, 13.7

folder-in-use locks, 2.4

invalid objects, editing, 12.4

parent, defined in glossary, Glossary

restoring from snapshots, 16.9.1.4

searching the navigation tree, 2.7.6, 2.7.6

selecting for deployment, 13.5

selecting objects to execute, 13.7.1

short name, defined in glossary, Glossary

supported by metadata snapshots, 16.1

synchronizing changes to locked objects, 2.4.3

syntax for business names, 2.6.2.1.1

syntax for logical names, 2.6.2.1.1

syntax for physical names, 2.6.2.1.2

using object editors, 2.7.3

validating, 12.2

write locks, 2.4

ODBC

for heterogeneous data sources, 4.1.2

OLAP

cube, defined in glossary, Glossary

data mart, defined in glossary, Glossary

data warehouse, defined in glossary, Glossary

OLAP, defined in glossary, Glossary

PL/SQL routines, 22.5.4

OLAP metadata

creating, 22.5.1

debugging export, 22.5.3.3

deploying, 22.5.3

exporting with OWB Transfer Wizard, 22.5.3

loading analytic workspace, 22.5.4

OLAP see online analytical processing, 22.4

OLAP Server, 22.2

OLE DB drivers

for heterogeneous data sources, 4.1.2

OMB PLUS, 6.1

OMB Plus

exporting metadata, 15.1

importing metadata, 15.1

metadata change management, 16.1

metadata snapshots, 16.1

online analytical processing, 22.4

opening

Deployment Manager, 13.3.1

operating modes

row based, 11.1.2.1, 11.2.1.2

row based (target only), 11.1.2.1, 11.2.1.3

selecting a default mode, 11.2.1

set based, 11.1.2.1, 11.2.1.1

set based fail over to row based, 11.1.2.1

set based fail over to row based (target only), 11.1.2.1

operating systems

flat files on Windows systems, 4.4

flat files residing on different operating systems, 4.4

UNIX, launching Warehouse Builder, 2.3.2

Windows, launching Warehouse Builder, 2.3.1

Operator Editor

about, 6.4

displaying, 6.4

General tab, 6.4

Groups tab, 6.4

Input tab, 6.4

Input/Output tab, 6.4

Output tab, 6.4

operator properties

for flat file operators, 6.6.3

for source operators, 6.6.1

for target operators, 6.6.1

loading types, 6.6.1.3, 6.6.3.1

types of, 6.6

operators

about, 6.2.2

adding to a mapping, 6.3

Advanced Queue operator, 8.10

Aggregator operator, 8.2

binding, defined in glossary, Glossary

bound operators, about, 6.3

connecting by attributes, 6.5.1

connecting by auto mapping, 6.5.2

connecting by groups, 6.5.2

connecting in mappings, 6.5

Constant operator, 8.3

data flow operator, defined in glossary, Glossary

data flow operators, adding, 6.3, 6.3

Data Generator operator, 8.4

Deduplicator operator, 8.5

editor for, 6.4

Expression operator, 8.6

Filter operator, 8.7

inbound reconciliation, 6.7.1

Joiner operator, 8.8

Key Lookup operator, 8.9

Mapping Flat File operator, 8.11, 11.1.5

Mapping Input Parameter operator, 8.12

Mapping Output Parameter operator, 8.13

Mapping Sequence operator, 8.14

Match-Merge operator, 8.15

Name and Address operator, 8.16

naming conventions, 6.4.1.2

Pivot operator, 8.17

Post-Mapping Process operator, 8.18

Pre-Mapping Process operator, 8.19

properties, 6.6

properties, types of, 6.6

reconciling operators, about, 6.7

renaming, 6.4

row set, defined in glossary, Glossary

Set Operation operator, 8.20

Sorter operator, 8.21

source operators, adding, 6.3.1

Splitter operator, 8.22

Table Function operator, 8.23

target operators, adding, 6.3.1

Transformation operator, 8.24

unbound operators, about, 6.3

Unpivot operator, 8.25

Oracle Designer 6i, 4.3

Application Systems, 4.3

source module, 4.3

workareas, 4.3

Oracle Heterogeneous Services, 4.1.2

Oracle Portal, 18.1

Oracle Transparent Gateways, 4.1.2, 4.1.3

Oracle Warehouse Builder Name and Address

purchasing license, 8.16.1

Oracle9i Discoverer, 22.2

Oracle9iAS Portal

about, 18.1.1

ORDER BY

in the Sorter operator, 8.21

organization

of flat file records, 4.5.4

orphaned snapshots, 16.9.1.4.3

outbound reconciliation

for operators, 6.7.2

Output Attributes

Name-Address operator, 8.16.3.6

Output Components

Name-Address operator, 8.16.3.6.1

selecting, for the Name-Address operator, 8.16.3.6

OWB PUBLIC VIEW ROLE, 2.2.1.3

OWB Transfer Wizard

deploying OLAP metadata, 22.5.3

P

packages

for process flows, 10.1.2

Parsing Type

Name-Address operator, 8.16.3.2.1

partition exchange loading

DML, defined in glossary, Glossary

Partition Exchange Loading (PEL), 11.3

about, 11.3.1

configuring mappings for, 11.3.2

configuring targets for, 11.3.5

performance considerations, 11.3.4

restrictions on, 11.3.5, 11.3.6

partition exchange loading (PEL), 11.1.4.4

partitions, 5.1.6

configuring, 5.1.6, 5.1.7.3

PEL See Partition Exchange Loading

performance

loading master-detail relationships, 8.11.6.4

warehouse keys, 3.10

physical aspects

cube table, 3.10

dimension table, 3.9

physical names

physical name mode, 2.6.2.1.2

syntax for physical object names, 2.6.2.1.2

Pivot operator

about, 8.17

editing, 8.17.3

example, 8.17.1

expressions for, 8.17.3.6

groups, 8.17.3.2

input attributes, 8.17.3.4

output attributes, 8.17.3.5

row locators, 8.17.2, 8.17.3.5

using, 8.17.3

PL/SQL

deploying PL/SQL scripts for transparent tables, 21.4.1

security plug-in specifications, 19.3.2

PL/SQL mappings, 11.1.1, 11.2

design considerations, 11.2.3

PL/SQL routines, 22.5.4

WB_OLAP_LOAD_CUBE, 22.5.4

WB_OLAP_LOAD_DIMENSION, 22.5.4

plug-ins

PL/SQL security package, interface specification, 19.3.2

pooled tables, 21.1.2

portal, launching, 14.2.2

portlets

about, 18.1.1

adding, to the Warehouse Builder Browser, 18.2

administration, 18.1.2.2

favorites, 17.1.2

Reports, 18.1.2.3

Post-Mapping Process operator, 8.18

preferences

base language, 2.6.1

choosing the display language, 2.6.1

clipboard preferences, 2.6.6

displaying welcome pages for wizards, 2.6.1

general Warehouse Builder client preferences, 2.6.1

locale, 2.6.1

message log preferences, 2.6.3

naming preferences, 2.6.2

recycle bin preferences, 2.6.6

setting browser preferences, 2.6.5

setting Warehouse Builder client preferences, 2.6

utilities preferences, 2.6.4

utilities, adding, 2.6.4.1

utilities, removing, 2.6.4.3

utilities, updating, 2.6.4.2

Pre-Mapping Process operator, 8.19

Primary Country

Name-Address operator, 8.16.3.2.2

primary keys, 3.3.7

primary source, 6.6.1.2

print report, 17.3.1

printing

Browser reports, 17.3.1

privileges

object, 2.2.2.1

system, 2.2.2.1

process flow activities

AND, 10.3.4.1

Email, 10.3.4.2

End, 10.3.4.3

External Process, 10.3.4.4

File Exists, 10.3.4.5

Fork, 10.3.4.6

FTP, 10.3.4.7

Mapping, 10.3.4.8

OR, 10.3.4.9

Start, 10.3.4.10

Subprocess, 10.3.4.11

Transform, 10.3.4.12

Process Flow Editor

about, 10.3

displaying, 10.3

navigating, 10.3.1

user interface, 10.3, 10.4

process flows

activities, 10.3.2

configuring, 11.4

creating, 10.2

editing, 10.3

error handling, 10.3.4.3

executing, 13.7

loading the analytic workspace, 22.5.4.2

modules, 10.1.1

packages, 10.1.2

passing in values, 10.3.2.2

Process Flow Editor, 10.3, 10.3

selecting process flows to execute, 13.7.1

transitions, 10.3.3

projects

archiving, about, 15.3.5

archiving, instructions, 15.3.5.3

backup with the Metadata Loader (MDL), 15

creating, 2.7.1.1

project navigation tree, 2.5.1

project, defined in glossary, Glossary

restoring, 15.4.5

restoring, instructions, 15.4.5.2

searching for objects, 2.7.6

properties

attribute properties, setting, 6.6.2

flat file operator properties, setting, 6.6.3

property sheets, 2.7.4

source operator properties, setting, 6.6.1

target operator properties, setting, 6.6.1

properties inspector

using, 5.3

Properties Windows

displaying, 6.6

for attributes, 6.6

for groups, 6.6

for operators, 6.6

property sheet

cube table, 3.10.2.1

dimension, 3.9.3.2

object, 3.9.3.2

table, 3.9.3.2

materialized view, 3.6.3

R

read-only mode, 2.4.2

read/write mode, 2.4.1

ending read/write mode, 2.4.1

RECNUM

in extracting from master-detail flat files, 8.11.6.4

in the Data Generator operator, 8.4.1

reconciliation

reconciliation vs. synchronization, 6.7

reconciling operators, about, 6.7

reconciling

advanced queues, 8.10.1.2

external table definitions, 3.4.4

inbound, 6.7.1

match strategies, 3.4.4

operators, about, 6.7

outbound, 6.7.2

reconcile strategies, 3.4.4

record numbers

in the Data Generator operator, 8.4.1

records

delimiter, defined in glossary, Glossary

extracting and loading master and detail records, 8.11.6.2

relationships between masters and details in flat files, 8.11.6

recycle bin

preferences, 2.6.6

reference materials

distributed database systems, 4.1.3

non-Oracle database systems, 4.1.3

registering

repositories, Runtime Audit Browser, 14.4.1

registering a Warehouse Builder user, 2.2.1.1

reimporting

advanced queues, 3.8.3

database definitions, 4.2.3

relational objects

defining, 3.2

relational online analytical processing, 22.5

relationships

between master and detail records, 8.11.6

REMAINING_ROWS output group

in the Splitter operator, 8.22

remote function call (RFC), 21.2.1

RFC connection, 21.2.1

SAP RFC connection, 21.2.1

removing

utilities from the utility drawer, 2.6.4.3

rename warehouse object

view, 3.5.3

renaming

indexes, 5.1.5

materialized views, 3.6.3

views, 3.5.3

reordering

table columns, 3.3.6

reports

accessing, 17.3

accessing from the client, 17.3.1

accessing from Warehouse Builder Browser, 17.3.2

adding custom reports to a role, 18.3.2.1

creating custom, 18.4

custom reports in Browser, 17.3.1.1

detailed dimension, 17.3.3.2

detailed fact, 17.3.3.2

detailed file, 17.3.3.2

detailed function, 17.3.3.2

detailed function library, 17.3.3.2

detailed installation, 17.3.3.2

detailed materialized view, 17.3.3.2

detailed module, 17.3.3.2

detailed record, 17.3.3.2

detailed sequence, 17.3.3.2

detailed table, 17.3.3.2

detailed transform map, 17.3.3.2

detailed view, 17.3.3.2

execution reports, 14.3.2.3

execution schedule reports, 14.3.2.1

execution summary reports, 14.3.2.2

implementation, 17.3.3.3

lineage and impact analysis, 17.3.3.4

lineage and impact analysis diagrams, 17.3.3.5

predefined in Warehouse Builder, 17.3.3

printing, 17.3.1

project, 17.3.3.2

registering custom, 18.3.2

runtime audit reports, 14.5

snapshot comparison reports, generating, 16.9.2.3

summary, 17.3.3.1

trace reports, 14.3.2.4

viewing custom Browser reports, 17.3.1.1

viewing custom reports, 17.3.1.1

viewing deployment reports, 14.3.1

viewing location reports, 14.3.1.3

viewing Runtime Repository reports, 14.3

Reports Portlet, 18.1.2.3

Reports Tab, 17.2.2.7

repositories

backup with the Metadata Loader (MDL), 15

design repository, defined in glossary, Glossary

editing repository information, Runtime Audit Browser, 14.4.1

managing access, Runtime Audit Browser, 14.4.1

registering, Runtime Audit Browser, 14.4.1

Runtime Audit Browser administration, 14.4.1

unregistering, in Runtime Audit Browser, 14.4.1

requirements

for business names, 2.6.2.1.1

reserved words, B.1

restoring

differences between restore and import, 15.4.5.1

metadata, 15.4.5

objects from snapshots, 16.9.1.4

parents of orphaned snapshots, 16.9.1.4.3

projects, 15.4.5

projects, instructions, 15.4.5.2

snapshots, 16.9.1.4

ROLAP see relational online analytical processing, 22.5

roles

adding custom reports, 18.3.2.1

administration, Runtime Audit Browser, 14.4.2

root snapshots

altering, 16.9.1.3

deleting non-root snapshots, 16.9.1.3

row based, 11.1.2.1, 11.2.1.2

row based (target only), 11.1.2.1, 11.2.1.3

row locators

in the Pivot operator, 8.17.2, 8.17.3.5

in the Unpivot operator, 8.25.2, 8.25.3.5

row sets

definition of, Glossary

rows

column, defined in glossary, Glossary

definition of, Glossary

RTRIM

in the Transformation operator, 8.24

rules

dimension object, 3.9.1

runtime

maximum number of errors, 11.1.2.4

Runtime Audit Browser

administration, 14.4

administrator list, 14.4.3

auditing deployment and execution, 14.2

available reports, 14.5

client, launching, 14.2.1

database links, 14.4.1

editing repository information, 14.4.1

execution reports, 14.3.2.3

execution summary reports, 14.3.2.2

integrated with Oracle9iAS, launching, 14.2.2

managing access to repositories, 14.4.1

registering repositories, 14.4.1

roles, administration, 14.4.2

trace reports, 14.3.2.4

viewing deployment reports, 14.3.1

viewing execution reports, 14.3.2

viewing location reports, 14.3.1.3

viewing reports, 14.3

Runtime Platform Service, about, 1.1.4.2

Runtime Repository

defining connections, 13.2.1

deployment information, 13.1

viewing deployment reports, 14.3.1

viewing reports, 14.3

runtime, SAP, 21.3.2.3

S

sampling

flat files, 4.5.2

master-detail flat files, 8.11.6.2

SAP

ABAP, defined in glossary, Glossary

configuring SAP file physical properties, 21.3.2

defining ETL process for SAP objects, 21.3

defining mappings with SAP objects, 21.3.1

defining SAP objects, 21.2

loading SAP data into the repository, 21.4

SAP ABAP Editor, 21.4

upload command, 21.4

SAP application

source module, 21.2.1

SAP Business Areas

about, 21.1.1

SAP file physical properties

Control File Name, 21.3.2.3

Data File Name, 21.3.2.3

File Delimiter for Staging File, 21.3.2.3

Log File Name, 21.3.2.3

Nested Loop, 21.3.2.3

SAP System Version, 21.3.2.3

Sequel Join Collapsing, 21.3.2.3

Staging File Directory, 21.3.2.3

Use Internal Table for Lookup only Table, 21.3.2.3

Use Single Select, 21.3.2.3

SAP File System Deployment dialog, 21.3.3

SAP Import From a Local File dialog, 21.4

SAP Integrator

about, 21.1

creating definitions, 21.2.1

objects supported, 21.2.2.2

required files, 21.2.1

SAP parameters

generation target directories, 21.3.2.4

loading type, 21.3.2.1

runtime, 21.3.2.3

step type, 21.3.2.2

SAP remote function call (SAPRFC.INI), 21.2.1

SAP table types

cluster, 21.1.2

importing, 21.1.2

pooled, 21.1.2

transparent, 21.1.2

SAPRFC.INI file, 21.2.1, 21.2.1, 21.2.1

saving

deployment scripts, 13.6

schemas

schema, defined in glossary, Glossary

snowflake schema, defined in glossary, Glossary

star schema, defined in glossary, Glossary

scripting

See OMB PLUS

scripts

generating, about, 12.5

saving deployment scripts, 13.6

searching

for objects in a project, 2.7.6

navigation tree, 2.7.6

second class objects (SCOs)

glossary definition, Glossary

security

ending read/write mode, 2.4.1

EXECUTE ALL PROCEDURES, 2.2.3

folder-in-use locks on objects, 2.4

multiple user account system, 2.2, 2.2.1

multiple-user access, 2.4

OWB PUBLIC VIEW ROLE, 2.2.1.3

PL/SQL package interface, 2.2.2

privileges, 2.2.2.1

read-only mode, 2.4.2

read/write mode, 2.4.1

registering a Warehouse Builder user, 2.2.1.1

requirements, 2.2.3

security registration service, 2.2

synchronizing changes to locked objects, 2.4.3

write locks on objects, 2.4

security registration service, 2.2, 2.2.2

selecting

objects for deployment, 13.5

objects to execute, 13.7.1

SEQUENCE

in the Data Generator operator, 8.4.3

sequences, 3.7

configuring, 5.11

defining, 3.7.2

editing, 3.7.3

for master-detail targets, 8.11.6.2

New Sequence Wizard, 3.7.2

sequence, defined in glossary, Glossary

server

client, defined in glossary, Glossary

servers

database server, defined in glossary, Glossary

services

heterogeneous services, 4.1.3

set based, 11.1.2.1, 11.2.1.1

set based fail over to row based, 11.1.2.1

set based fail over to row based (target only), 11.1.2.1

Set Operation operator, 8.20

intersect, 8.20

minus, 8.20

union, 8.20

union all, 8.20

setting

browser preferences, 2.6.5

clipboard preferences, 2.6.6

display language preferences, 2.6.1

locale preferences, 2.6.1

message log preferences, 2.6.3

naming preferences, 2.6.2

recycle bin preferences, 2.6.6

utilities preferences, 2.6.4

Warehouse Builder client preferences, 2.6

wizard preferences, 2.6.1

Setting the Generation Target Directories, 21.3.2.4

Setting the Runtime Parameter, 21.3.2.3

Setting the Step Type Parameter, 21.3.2.2

short name

defining, Glossary

reserved words, B.1

signature snapshots

about, 16.2.1

signature, cascade snapshots, 16.2.3

signature, no cascade snapshots, 16.2.3

snapshots

altering metadata snapshots, 16.9.1.3

backing up metadata with snapshots, 16

cascading, about, 16.2.2

change management, 16.9.2

comparison reports, 16.9.2

comparison reports, generating, 16.9.2.3

converting full to signature, 16.2.1

deleting non-root snapshots, 16.9.1.3

deployment, using during, 16.10.1

exporting snapshots, 16.9.1.5

full snapshots, 16.2.1, 16.2.2

full to signature, converting, 16.2.1

full/signature, about, 16.2.1

history management, 16.9.1

impact analysis, using with, 16.10.1

importing snapshots, 16.9.1.5

MDL metadata import, using with, 16.10.1

metadata snapshots, about, 16.1

no cascade snapshots, 16.2.2

orphaned snapshots, 16.9.1.4.3

restoring, 16.9.1.4

signature snapshots, 16.2.1

supported objects, 16.1

type combinations, 16.2.3

usage suggestions, 16.10

snowflakes

snowflake schema, defined in glossary, Glossary

software integrators

about, 4.1

Oracle Transparent Gateways, 4.1.2

sorted indexes, 11.1.4.7

Sorter operator, 8.21

ORDER BY, 8.21

source data

cleansing, defined in glossary, Glossary

data source, defined in glossary, Glossary

source locations, Deployment Manager, 13.3.2.1

source module

connection information

SAP source, 21.2.1

SAP application, 21.2.1

source modules, 4

connection information, 4.1.3

creating, 4.1

database links, 4.1.3

defining SAP objects, 21.2

flat files, 4.5

importing definitions, 4.2.2

Oracle Designer 6i, 4.3.1

Oracle Designer Repository, 4.3

source operators

primary source, 6.6.1.2

properties, 6.6.1

sources

cleansing, defined in glossary, Glossary

data source, defined in glossary, Glossary

data sources, 4

database source modules, about, 4.2

database, defined in glossary, Glossary

defining SAP objects, 21.2

delimited flat file, defined in glossary, Glossary

flat file source operators, about, 8.11.1

flat file source operators, importing/binding, 8.11.4

flat file source operators, previously imported, 8.11.3

flat file sources, about, 4.5

master-detail flat file sources, 8.11.6

master-detail flat files, 8.11.6

master-detail flat files, example, 8.11.6

module, defined in glossary, Glossary

source, defined in glossary, Glossary

updating source definitions, 4.2.4

Splitter operator, 8.22

REMAINING_ROWS output group, 8.22

SQL properties

for flat files, 4.5.9.2

SQL*Loader

datatypes, 4.5.9.1.2

parameters, 6.6.1.4

properties for flat files, 4.5.9.1

starting

Warehouse Builder, 2.3

step type, SAP, 21.3.2.2

summarizing

data with a transformation, 8.2

surrogate keys

in the Key Lookup operator, 8.9

T

table editor, 3.3.2

Table Function operator, 8.23

prerequisites, 8.23.1

using, 8.23.2.5

table functions, 11.1.3.3

table properties

dimension table, 3.9.3.2

tables, 3.3

adding columns, 3.3.5

column, defined in glossary, Glossary

columns, 3.3.1.1, 3.3.5

configuring, 5.4

constraint, defined in glossary, Glossary

constraints, 3.3.1.1

cube, defined in glossary, Glossary

data types, 3.3.5

database link, defined in glossary, Glossary

defining, 3.3.1

defining cubes, 3.10.1

denormalize, defined in glossary, Glossary

deploying PL/SQL scripts for transparent tables, 21.4.1

derived fact (or measure), defined in glossary, Glossary

dimension, defined in glossary, Glossary

editing, 3.3.2, 3.3.3

length, 3.3.5

naming, 3.3.1.1

New Cube Wizard, 3.10.1

New Table Wizard, 3.3.1

precision, 3.3.5

related tables, 3.3.2.1

renaming, 3.3.4

reordering columns, 3.3.6

reports, 3.3.2.3

row set, defined in glossary, Glossary

row, defined in glossary, Glossary

scale, 3.3.5

table, defined in glossary, Glossary

tabs

reports, 17.2.2.7

target operators

properties, 6.6.1

target systems

deploying and updating, 13.2

targets

database, defined in glossary, Glossary

delimited flat file, defined in glossary, Glossary

flat file operators, inserting new, unbound, 8.11.5

flat file target operators, about, 8.11.1

flat file target operators, importing/binding, 8.11.4

flat file target operators, multiple record types, 8.11.2

flat file target operators, previously imported, 8.11.3

flat file targets, about, 4.5

module, defined in glossary, Glossary

multiple targets in a mapping, 11.2.2

multiple targets in mappings, 8.22, 8.22.1, 11.1.3.5

sequences for master-detail target tables, 8.11.6.2

target, defined in glossary, Glossary

terms

glossary, Glossary

time dimensions

creating, 3.9.3.2

toolbars

commit, 2.3.3.1

Deployment Manager toolbar, 13.3.2.4

horizontal toolbar in Warehouse Builder console, 2.5.2

property icon, 2.7.4

transactions

commit, defined in glossary, Glossary

Transfer Wizard

about, 22.3

bridge, defined in glossary, Glossary

CWM, defined in glossary, Glossary

log file

export, 22.3.3

log file, export, 22.3.2

version, 22.3.2

transformation

create definition, 9.3

custom example, 9.3

filter data, 9.3

Transformation operator, 8.24

CHAR, 8.24, 8.24

CHAR result RTRIM, 8.24

data type, 8.24

RTRIM, 8.24

transformations, 8

group by operation, 8.2

names, unique, 2.6.2.1

Transformation Library, defined in glossary, Glossary

transformation, defined in glossary, Glossary

transitions, 10.3.3.1

about, 10.3.3

conditional transitions, 10.3.3

transparent

agents, 4.1.3

transparent tables, 21.1.2

tree

deploying objects from the navigation tree, 13.2.2

deployment tree, 13.3.2.1

trees

project navigation tree, 2.5.1

TRUNCATE/INSERT, 6.6.1.3

U

unbound

operators, about, 6.3

union

in the Set Operation operator, 8.20

union all

in the Set Operation operator, 8.20

unique

transformation names, 2.6.2.1

unique key

constraint on levels, 3.9.1.2

unique keys, 3.3.7

Universal Object Identifiers

and Metadata Loader

UNIX operating systems

launching Warehouse Builder, 2.3.2

Unpivot operator

about, 8.25

editing, 8.25.3

example, 8.25.1

expressions for, 8.25.3.7

groups, 8.25.3.2

input attributes, 8.25.3.4

input connections, 8.25.3.3

output attributes, 8.25.3.6

row locators, 8.25.2, 8.25.3.5

using, 8.25.3

UOIDs See Universal Object Identifiers

UPDATE, 6.6.1.3

update (operation), 6.6.2.9

target conditions, 6.6.2.9

update definition

view, 3.5.3

UPDATE/INSERT, 6.6.1.3

updating

connection information, data sources, 4.2.4.2

flat file definitions, 4.5.10

source definitions, 4.2.4

target systems, 13.2

utilities, 2.6.4.2

updating SAP object definitions, 21.2.3

user interface

navigation tree folders, 2.5.1

project navigation tree, 2.5.1

Warehouse Builder console, 2.5

User's Guide

glossary of terms, Glossary

utilities

adding, to the utility drawer, 2.6.4.1

mcmview.bat, 16.9.2.3

Metadata Loader command line utility, 15.5

removing, from the utility drawer, 2.6.4.3

setting utilities preferences, 2.6.4

snapshot comparison reports, 16.9.2.3

updating utilities, 2.6.4.2

utility drawer

adding utilities, 2.6.4.1

removing utilities, 2.6.4.3

V

validating

about, 12.1

Deployment Manager, defined in glossary, Glossary

editing invalid objects, 12.4

objects, 12.2

validation

about, 12.1

editing invalid objects, 12.4

message editor, 12.3.2.1

object editor, 12.3.2.1

results, 12.2

results, evaluating, 12.3

Validation Results Dialog, 12.2

validation, defined in glossary, Glossary

viewing details, 12.3.2.1

VARCHAR, 3.3.5.1

VARCHAR2, 3.3.5.1

version, Warehouse Builder, 21.1.3

versions

archiving projects, 15.3.5.1

bridges, 22.3.2

Transfer Wizard, 22.3.2

viewing

custom Browser reports, 17.3.1.1

custom reports, 17.3.1.1

deployment history, 13.5.1

views, 3.5

defining, 3.5.2

editing, 3.5.3

New View Wizard, 3.5.2

renaming, 3.5.3

W

Warehouse Builder

about Warehouse Builder, 1.1

benefits, 1.2

components, 1.1.4

console, 2.5

glossary of terms, Glossary

launching Warehouse Builder, 2.3

predefined reports, 17.3.3

project navigation tree, 2.5.1

setting client preferences, 2.6

starting Warehouse Builder, 2.3

user interface, 2.5

Warehouse Builder Browser

adding custom reports to a role, 18.3.2.1

administration, 18.3

administration portlet, 18.1.2.2

browsing the favorites, 17.2.3

contents tab, 17.2.2.5

creating custom reports, 18.4

creating database links, 18.3.1.2

current item information, 17.2.2.2

customizing favorites, 17.2.4

dropping database links, 18.3.1.5

editing database links, 18.3.1.4

implementation reports, 17.3.3.3

lineage and impact analysis diagrams, 17.3.3.5

lineage and impact analysis reports, 17.3.3.4

portlets, adding, 18.2

QA user role, 18.3.3.1

registering a custom report, 18.3, 18.3.2

registering a repository, 18.3, 18.3.1

related tab, 17.2.2.6

reports tab, 17.2.2.7

reports, accessing, 17.3.2

roles, 18.3.3.1

setting preferences, 2.6.5

summary reports, 17.3.3.1

unregistering a repository, 18.3.1.6

viewing database links, 18.3.1.3

warehouse developer role, 18.3.3.1

warehouse user role, 18.3.3.1

warehouse keys

column, 3.9.2

performance, 3.10

warehouse modules

configuring, 5.3

renaming materialized views, 3.6.3

renaming views, 3.5.3

warehouse objects

renaming materialized views, 3.6.3

renaming views, 3.5.3

WB_OLAP_LOAD_CUBE, 22.5.4

WB_OLAP_LOAD_DIMENSION, 22.5.4

WHERE

in the Filter operator, 8.7

Windows operating systems

launching Warehouse Builder, 2.3.1

wizards

Archive Wizard, 15.3.5.3

External Table Wizard, 3.4.2

Flat File Sample Wizard, 4.5.2

Import Metadata Wizard, 4.2.2, 4.5.1

Match-Merge Wizard, 8.15.3

New Collection Wizard, 22.2.1

New Cube Wizard, 3.10.1, 3.10.1

New Dimension Wizard, 3.9.2

New External Table Wizard, 3.4.2

New Mapping Wizard, 6.2

New Materialized View Wizard, 3.6.2

New Sequence Wizard, 3.7.2

New Table Wizard, 3.3.1

New Transformation Wizard, 9.3

New View Wizard, 3.5.2

Pivot Wizard, 8.17.3

Restore Wizard, 15.4.5.2

Transfer Wizard, 22.3

Unpivot Wizard, 8.25.3

using Warehouse Builder wizards, 2.7.2

welcome pages, displaying, 2.6.1

workareas

Designer 6i, 4.3

Workflow Management Consortium (WfMC), 10.1

write locks

on objects, 2.4

X

XML

XML Process Definition Language(XPDL), 10.1

Z

ZONED, 4.5.9.1.2