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
- See also Advanced Queue operator
- advanced reconcile options, 3.8.3, 4.2.3
- agents
-
- agent, defined in glossary, Glossary
- connectivity agent, defined in glossary, Glossary
- transparent gateways, 4.1.3
- aggregation
-
- aggregation, defined in glossary, Glossary
- mixed levels, 3.9.1.3
- Aggregator operator, 8.2
-
- aggregate, defined in glossary, Glossary
- aggregation, defined in glossary, Glossary
- ALL, 8.2
- DISTINCT, 8.2
- GROUP BY, 8.2
- HAVING, 8.2
- ALL
-
- in the Aggregator operator, 8.2
- ALTER
-
- metadata snapshots, 16.9.1.3
- altering
-
- metadata snapshots, 16.9.1.3
- analytic workspace, 22.4.1
-
- loading, 22.5.4
- OLAP DML, 22.4.1
- analytic workspaces
-
- analytic workspace, defined in glossary, Glossary
- analyzing
-
- statistics and targets, 11.1.2.7
- table estimate percent, 5.4.1
- ancestors
-
- ancestor, defined in glossary, Glossary
- API
-
- API, defined in glossary, Glossary
- AQ See advanced queues
- architecture
-
- client, defined in glossary, Glossary
- database server, defined in glossary, Glossary
- archiving
-
- archive, defined in glossary, Glossary
- differences between archive and export, 15.3.5.2
- project version labels, 15.3.5.1
- projects, about, 15.3.5
- projects, instructions, 15.3.5.3
- attribute properties
-
- load column when deleting row, 6.6.1.7
- load column when inserting row, 6.6.2.6
- load column when updating row, 6.6.1.7, 6.6.2.7
- match column when deleting row, 6.6.2.10
- match column when updating row, 6.6.1.7, 6.6.2.8
- attribute sets
-
- attribute sets, defined in glossary, Glossary
- attributes
-
- adding to mappings, 6.4, 6.4
- attribute sets, adding, 3.3.9
- attribute sets, defined in glossary, Glossary
- attribute, defined in glossary, Glossary
- connecting in mappings, 6.5.1
- datatype, defined in glossary, Glossary
- deleting from mappings, 6.4
- editing, 6.4
- naming conventions, 6.4.1.1
- properties, 6.6, 6.6.2
- renaming, 6.4
- See also attribute properties
- auditing
-
- deployment and execution, 14
- Runtime Audit Browser, 14.2
- runtime audit reports, 14.5
- auto mapping
-
- See connecting
- AW see analytic workspace, 22.4.1
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
- See also metadata history management
- CHAR, 3.3.5.1
-
- in the Transformation operator, 8.24, 8.24
- character sets, 4.5.3
-
- in external tables, 5.5.4
- multibyte, 5.5.4
- check keys, 3.3.7
- CHECK/INSERT, 6.6.1.3
- cleansing
-
- cleansing, defined in glossary, Glossary
- clients
-
- client, defined in glossary, Glossary
- clipboard
-
- preferences, 2.6.6
- cluster tables, 21.1.2
- code generation
-
- configuring target directories, 5.3
- code viewer
-
- SAP, 21.3.3
- collections
-
- about, 22.5.2
- collection, defined in glossary, Glossary
- creating, 22.2.1
- defining for OLAP, 22.5.2
- deleting shortcuts in, 22.2
- editing, 22.2.2
- New Collection Wizard, 22.2.1
- columns
-
- column, defined in glossary, Glossary
- datatype, defined in glossary, Glossary
- command line utilities
-
- importing metadata, 15.5.3
- commit
-
- commit, defined in glossary, Glossary
- design changes, 2.3.3.1
- frequency, 11.1.2.5
- synchronizing changes to locked objects, 2.4.3
- commit strategies, 11.2.2.1
-
- committing to multiple targets, 11.2.2
- correlated commit, 11.2.2.1
- independent commit, 11.2.2.1
- Common Warehouse Model
-
- Common Warehouse Model, defined in glossary, Glossary
- comparing
-
- metadata snapshot comparison reports, 16.9.2
- snapshot comparison reports, 16.9.2.3
- compressing
-
- mappings, 6.4.3
- conditional loading settings
-
- delete target condition, 6.6.1.6
- target filter for update, 6.6.1.5
- configuration properties
-
- ABAP directory, 5.3
- ABAP extension, 5.3
- ABAP run parameter file, 5.3
- ABAP spool directory, 5.3
- analyzing statistics and targets, 11.1.2.7
- analyzing table estimate percent, 5.4.1
- archive directory, 5.3
- bulk processing, 11.1.3.1
- commit frequency, 11.1.2.5
- DDL directory, 5.3
- DDL extension, 5.3
- DDL spool directory, 5.3
- default audit level, 11.1.2.3
- default index tablespace, 5.3
- default object tablespace, 5.3
- default purge group, 11.1.2.6, 11.1.7
- dimension, 5.7
- end of line, 5.3
- hints, 11.1.4.5
- input directory, 5.3
- invalid directory, 5.3
- lib directory, 5.3
- lib extension, 5.3
- lib spool directory, 5.3
- loader directory, 5.3
- loader extension, 5.3
- loader run parameter file, 5.3
- log directory, 5.3
- logging mode, 5.4.1
- maximum number of errors, 11.1.2.4
- parallel, 5.4.2, 5.5.3
- partition exchange loading, 11.1.4.4
- PL/SQL directory, 5.3
- PL/SQL extension, 5.3
- PL/SQL Generation Mode, 5.3
- PL/SQL run parameter file, 5.3
- PL/SQL spool directory, 5.3
- receive directory, 5.3
- sequences, 5.11
- sort directory, 5.3
- SQL*Loader parameters, 6.6.1.4
- tablespace, 5.4.3
- using index, 5.4.6
- work directory, 5.3
- configuring
-
- advanced queues, 5.6
- connections for database sources, 4.1.3
- conventional views, 5.10
- cubes, 5.8
- default audit level, 11.1.2.3
- dimensions, 5.7
- external tables, 5.5
- flat file physical properties, 11.1.5
- flat file targets, 11.1.6
- for PEL, 11.3.2
- indexes, 5.1.4
- mapping runtime parameters, 11.1.2
- mapping sources and targets, 8.22.1, 11.1.3.5
- mappings, 11.1
- master-detail mappings, conventional path load, 8.11.6.2
- master-detail mappings, direct path load, 8.11.6.4
- materialized views, 5.9
- partitions, 5.1.6, 5.1.7.3
- partitions, DDL
- PL/SQL mappings, 11.2
- process flows, 11.4
- runtime parameters, 5.2
- runtime parameters, SAP files, 21.3.2.3
- SAP file physical properties, 21.3.2
- SAP, loading type parameter, 21.3.2.1
- sequences, 5.11
- tables, 5.4
- updating utilities, 2.6.4.2
- validating objects, 12.2
- warehouse modules, 5.3
- connecting
-
- attributes in mappings, 6.5.1
- connection, defined in glossary, Glossary
- connector, defined in glossary, Glossary
- database link, defined in glossary, Glossary
- groups in mappings, 6.5.2
- operators in mappings, 6.5
- connection information
-
- non-Oracle database systems, 4.1.3
- remote function call (RFC), 21.2.1
- SAP application, 21.2.1
- source modules, 4.1.3
- connection type, 21.2.1
- connections
-
- defining Runtime Repository connections, 13.2.1
- updating connection information, 4.2.4.2
- connectivity
-
- connection, defined in glossary, Glossary
- connectivity agent, defined in glossary, Glossary
- database link, defined in glossary, Glossary
- ODBC, 4.1.2
- OLE DB drivers for heterogeneous data sources, 4.1.2
- connectivity agent, 4.1.2
- connectors
-
- about, 3.1.2
- connector, defined in glossary, Glossary
- creating, 3.1.2.1
- database link, defined in glossary, Glossary
- defining, 3.1.2
- editing, 3.1.2.2
- console
-
- clipboard, defined in glossary, Glossary
- collection, defined in glossary, Glossary
- console, defined in glossary, Glossary
- Constant operator, 8.3
- constraint
-
- cube table foreign key references, 3.10
- unique key constraint on levels, 3.9.1.2
- Constraint operator
-
- constraint, defined in glossary, Glossary
- constraints
-
- check key, 3.3.7
- constraint, defined in glossary, Glossary
- cube foreign key references, 3.10.1
- DEFAULTIF, Flat File Sample wizard, 4.5.9.1.5
- defining, 3.3.7.1
- deleting, 3.3.8
- editing, 3.3.7
- foreign key, 3.3.7
- match by options, 6.6.1.7
- NULLIF, in the Flat File Sample wizard, 4.5.9.1.4
- primary key, 3.3.7
- unique key, 3.3.7
- containers
-
- Oracle Designer Repository, 4.3
- SAP application, 21.2.1
- source modules, 4.1
- conventional path loading
-
- for master-detail relationships, 8.11.6.2
- master-detail flat files, sample mapping, 8.11.6.2
- conventional views
-
- configuring, 5.10
- renaming, 3.5.3
- converting
-
- full snapshots to signature, 16.2.1
- Copy and Map Wizard
-
- using, 21.3.1.2
- correlated commit, 11.2.2.1
-
- design considerations, 11.2.2.2
- create definition
-
- hierarchy, 3.9.2
- transformation, 9.3
- creating
-
- advanced queues, 8.10.1
- collections, 22.2.1
- connectors, 3.1.2.1
- custom reports in Browser, 17.3.1.1
- database links, 4.1.3, 18.3.1.2
- dimensions, 3.9.2
- indexes, 5.1.2
- locations, 3.1.1.1
- mappings, 6
- mappings, New Mapping Wizard, 6.2
- objects in a project, 2.7
- objects, bound name, defined in glossary, Glossary
- objects, business name, defined in glossary, Glossary
- OLAP metadata, 22.5.1
- Oracle Designer 6i source modules, 4.3.1
- physical objects, 5.3
- process flows, 10.2
- projects, 2.7.1.1
- Runtime Repository connections, 13.2.1.1
- source modules, 4.1
- time dimension, 3.10
- time dimensions, 3.9.3.2
- Cross Reference Output, 8.15.3.6
- cube tables, 3.10
-
- defining foreign key references, 3.10.1
- physical aspects, 3.10
- property sheet, 3.10.2.1
- update definition, 3.10.2
- cubes, 3.10
-
- configuring, 5.8
- cube, defined in glossary, Glossary
- defining, 3.10.1, 3.10.1
- defining for OLAP, 22.5.1.2
- derived fact (or measure), defined in glossary, Glossary
- dimension, defined in glossary, Glossary
- editing, 3.10.2
- New Cube Wizard, 3.10.1, 3.10.1
- customizing
-
- Browser favorites page, 17.2.4
- viewing custom Browser reports, 17.3.1.1
- CWM, 22.2
-
- CWM, defined in glossary, Glossary
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
- See also sources
- updating connection information, 4.2.4.2
- data transformation, 8
- data type
-
- in the Transformation operator, 8.24
- data types
-
- CHAR, 3.3.5.1
- DATE, 3.3.5.1
- flat file field, 4.5.9.1.2
- FLOAT, 3.3.5.1
- NUMBER, 3.3.5.1
- portable, 4.5.9.1.2
- tables, 3.3.5
- VARCHAR, 3.3.5.1
- VARCHAR2, 3.3.5.1
- data warehouses
-
- cube, defined in glossary, Glossary
- data mart, defined in glossary, Glossary
- data warehouse, defined in glossary, Glossary
- derived fact (or measure), defined in glossary, Glossary
- dimension, defined in glossary, Glossary
- database links
-
- adding, Runtime Audit Browser, 14.4.1
- New Database Link dialog, 4.1.3
- Oracle database system, 4.1.3
- SAP, 21.2.1
- source modules, 4.1.3
- viewing, Runtime Audit Browser, 14.4.1
- databases
-
- client, defined in glossary, Glossary
- column, defined in glossary, Glossary
- commit, defined in glossary, Glossary
- configuring database source connections, 4.1.3
- connection, defined in glossary, Glossary
- connectivity agent, defined in glossary, Glossary
- constraint, defined in glossary, Glossary
- data warehouse, defined in glossary, Glossary
- database link, defined in glossary, Glossary
- database object, defined in glossary, Glossary
- database server, defined in glossary, Glossary
- database source modules, about, 4.2
- database, defined in glossary, Glossary
- denormalize, defined in glossary, Glossary
- importing definitions from, 4.2.2
- non-Oracle database systems, 4.1.3
- reimporting definitions, 4.2.3
- datatypes
-
- datatype, defined in glossary, Glossary
- DATE, 3.3.5.1
- DDL See data definition language
- debugging
-
- OLAP metadata export, 22.5.3.3
- Deduplicator operator, 8.5
-
- DISTINCT, 8.5
- default audit level
-
- configuration properties, 11.1.2.3
- default purge group, 11.1.2.6, 11.1.7
- DEFAULTIF
-
- constraint, Flat File Sample wizard, 4.5.9.1.5
- defaults
-
- audit level, configuration properties, 11.1.2.3
- naming mode, 2.6.2.2
- operating mode, 11.1.2.1
- defining
-
- collections for OLAP, 22.5.2
- connectors, 3.1.2
- constraints, 3.3.7.1
- cubes, 3.10.1, 3.10.1
- cubes for OLAP, 22.5.1.2
- dimensions, 3.9.2
- dimensions for OLAP, 22.5.1.1
- display sets, 6.4.2.1
- ETL process for SAP objects, 21.3
- locations, 3.1.1
- mappings, 6, 6.1.2
- mappings containing SAP objects, 21.3.1
- mappings, New Mapping Wizard, 6.2
- materialized views, 3.6.2
- relational objects, 3.2
- Runtime Repository connections, 13.2.1
- SAP objects, 21.2
- sequences, 3.7.2
- tables, 3.3.1
- updating flat file definitions, 4.5.10
- updating source definitions, 4.2.4
- validating objects, 12.2
- views, 3.5.2
- definition
-
- attribute, 3.9.2
- transformation, 9.3
- warehouse key column, 3.9.2
- definitions
-
- glossary of terms, Glossary
- importing definitions from a database, 4.2.2
- reimporting database definitions, 4.2.3
- validating, 12.2
- DELETE, 6.6.1.3
- DELETE/INSERT, 6.6.1.3
- deleting
-
- attributes from mappings, 6.4
- constraints, 3.3.8
- groups from mappings, 6.4
- delimited flat files
-
- importing, 4.5.4
- delimiters
-
- delimited flat file, defined in glossary, Glossary
- delimiter, defined in glossary, Glossary
- deploying
-
- about, 13.1
- auditing deployment, 14
- auditing with Runtime Audit Browser, 14.2
- completing deployment, 13.5.2
- connector, defined in glossary, Glossary
- Deployment Manager, defined in glossary, Glossary
- deployment tree, 13.3.2.1
- deployment, defined in glossary, Glossary
- executing deployed objects, 13.7
- objects, 13.2.2
- objects from the navigation tree, 13.2.2
- objects with the Deployment Manager, 13.2.2
- OLAP metadata, 22.5.3
- PL/SQL scripts for transparent tables, 21.4.1
- prerequisites, 13.2
- saving deployment scripts, 13.6
- selecting objects for deployment, 13.5
- target systems, 13.2
- using metadata snapshots during deployment, 16.10.1
- viewing deployment history, 13.5.1
- viewing deployment schedule reports, 14.3.1.1
- viewing location reports, 14.3.1.3
- viewing object summary reports, 14.3.1.2
- deployment
-
- cube, defined in glossary, Glossary
- database link, defined in glossary, Glossary
- Deployment Manager
-
- about, 13.2, 13.3
- deploying objects with, 13.2.2
- Deployment Manager, defined in glossary, Glossary
- deployment tree, 13.3.2.1
- Details tab, 13.3.2.2
- History tab, 13.3.2.3
- opening, 13.3.1
- saving deployment scripts, 13.6
- selecting objects for deployment, 13.5
- toolbar, 13.3.2.4
- using, 13.3
- viewing deployment history, 13.5.1
- describing
-
- flat files in the Flat File Sample Wizard, 4.5.3
- design repository
-
- design repository, defined in glossary, Glossary
- Designer 6i, 4.3
-
- workareas, 4.3
- dialog
-
- folder, 21.2.2.2
- Dimension
-
- Hierarchies, 3.9
- dimension
-
- attribute definition, 3.9.2
- basic definition, 3.9
- define a level of aggregation, 3.9.2
- denormalized dimension table, 3.9.1.3
- dimension object, 3.9, 3.9
- hierarchies, 3.9.2, 3.9.2
- levels, 3.9.1.1
- products
-
- create, 3.9.2
- property sheet, 3.9.3.2
- table property sheet, 3.9.3.2
- time dimension, 3.9.3.2
- update, 3.9.3
- dimension table
-
- physical aspects, 3.9
- dimensional objects, 3.2
- dimensions, 3.9
-
- configuring, 5.7
- creating, 3.9.2
- creating time dimensions, 3.9.3.2
- defining, 3.9.2
- defining for OLAP, 22.5.1.1
- dimension value, defined in glossary, Glossary
- dimension, defined in glossary, Glossary
- editing, 3.9.3
- editor, 3.9.3.1
- New Dimension Wizard, 3.9.2
- property sheet, 3.9.3.2
- direct path loading
-
- for master-detail relationships, 8.11.6.4, 8.11.6.4
- master-detail flat files, sample mapping, 8.11.6.4
- display sets
-
- about, 6.4.2
- defining, 6.4.2.1
- selecting, 6.4.2.2
- using, 6.4.2
- displaying
-
- Process Flow Editor, 10.3
- properties, 2.7.4
- setting the display language, 2.6.1
- welcome pages for wizards, 2.6.1
- DISTINCT, 6.2.2.2
-
- in the Aggregator operator, 8.2
- in the Deduplicator operator, 8.5
- Dual Address Assignment
-
- Name-Address operator, 8.16.3.2.3
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
- loading
-
- 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
- See also operators
- Mapping Output Parameter operator, 8.13
-
- about, 8.13
- properties, 8.13
- using, 8.13
- Mapping Sequence operator, 8.14
-
- extracting from master-detail flat files, 8.11.6
- Mapping Sequence operator with master-detail flat file sources, 8.11.6
- mappings
-
- about, 6.1
- compressing, 6.4.3
- configuring, 11.1, 11.2
- connecting operators, 6.5
- data flow operators, adding, 6.3, 6.3
- defining, 6
- defining mappings with SAP objects, 21.3.1
- defining, steps for, 6.1.2
- display sets, 6.4.2
- display sets, defining, 6.4.2.1
- display sets, selecting, 6.4.2.2
- editing, 6.2.1
- executing, 13.7
- flat file sources, 11.1.5
- flat file targets, 11.1.5
- groups, 6.4, 6.4
- loading the analytic workspace, 22.5.4.1
- Mapping Editor, 6.2.1
- mapping, defined in glossary, Glossary
- maximum number of errors, 11.1.2.4
- New Mapping Wizard, 6.2
- operators, 6.2.2
- operators, adding, 6.3
- operators, connecting, 6.5
- PL/SQL mappings, 11.2
- prerequisites for advanced queue execution, 8.10.3
- renaming objects in, 6.4
- runtime parameters, configuring, 11.1.2
- selecting mappings to execute, 13.7.1
- source operators, adding, 6.3.1
- sources and targets, configuring, 8.22.1, 11.1.3.5
- target operators, adding, 6.3.1
- transformations, 8
- using in process flows, 10.3.4.8
- master-detail flat files
-
- as sources, about, 8.11.6
- configuring mappings, conventional path load, 8.11.6.2
- configuring mappings, direct path load, 8.11.6.4
- Data Generator operator, 8.11.6.4
- example of a master-detail flat file, 8.11.6
- extracting from, 8.11.6.2
- extracting from, using conventional path load, 8.11.6.2
- extracting from, using direct path load, 8.11.6.4
- importing and sampling, 8.11.6.2
- operations after initial load, 8.11.6.5
- performance, 8.11.6.2, 8.11.6.4
- post-update scripts for direct path loads, 8.11.6.4
- RECNUM, 8.11.6.4
- sample mapping, conventional path loading, 8.11.6.2
- sample mapping, direct path loading, 8.11.6.4
- sequences in target tables, 8.11.6.2
- Match bins, 8.15.3.7
- match by constraint, 6.6.1.7
- match column when
-
- deleting row, 6.6.2.10
- updating row, 6.6.1.7
- match column when updating row, 6.6.2.8
- Match rules, 8.15.4
-
- active, 8.15.3.9
- Address rule, 8.15.4.3
- Conditional rule, 8.15.4.4
- custom rules, 8.15.3.11
- Firm rule, 8.15.4.5
- multiple match rules, 8.15.4.1
- passive, 8.15.3.10
- Person rule, 8.15.4.6
- transitive match rules, 8.15.4.2
- Weight rule, 8.15.4.7
- Match-Merge operator, 8.15
-
- concepts, 8.15.4
- custom rules, 8.15.3.11, 8.15.3.13
- design considerations, 8.15.2, 8.15.5
- editing, 8.15.3
- example, 8.15.1
- groups, 8.15.3.2
- using, 8.15.3
- materialized views, 3.6
-
- configuring, 5.9
- defining, 3.6.2
- editing, 3.6.3
- fast refresh, 5.9.2
- materialized view editor, 3.6.3
- New Materialized View Wizard, 3.6.2
- renaming, 3.6.3
- update definitions, 3.6.3
- mcmview.bat
-
- snapshot comparison reports, 16.9.2.3
- MDL See Metadata Loader
- measures
-
- additive measures, defined in glossary, Glossary
- Merge rules, 8.15.3.12
-
- custom, 8.15.3.13
- messages
-
- message log preferences, 2.6.3
- metadata
-
- archiving instructions, 15.3.5.3
- archiving, about, 15.3.5
- archiving, defined in glossary, Glossary
- backup using snapshots, 16
- backup with the Metadata Loader (MDL), 15
- change management using snapshots, 16
- change management with snapshots, 16.9.2
- change management, OMB Plus, 16.1
- differences between archive and export, 15.3.5.2
- differences between restore and import, 15.4.5.1
- exporting metadata, 15.3
- exporting snapshots, 16.9.1.5
- exporting, using the Transfer Wizard, 22.3.3
- history management, 16
- implementation reports, 17.3.3.3
- import and export, overview, 15.1
- Import Metadata Wizard, 4.2.2
- import modes, 15.4.4.1
- importing from databases, 4.2.2
- importing metadata, 15.4
- importing snapshots, 16.9.1.5
- importing, about, 15.4
- importing, matching criteria, 15.4.4.2
- importing, validation rules, 15.4.3
- lineage and impact analysis diagrams, 17.3.3.5
- lineage and impact analysis reports, 17.3.3.4
- metadata, defined in glossary, Glossary
- restoring, 15.4.5
- restoring instructions, 15.4.5.2
- restoring snapshots, 16.9.1.4
- snapshots, about, 16.1
- snapshots, objects supported by, 16.1
- summary reports, 17.3.3.1
- metadata history management, 16
-
- See also snapshots
- Metadata Loader
-
- about, 15.2
- access privileges, 15.2.1
- archiving, defined in glossary, Glossary
- command line utility, 15.5
- creating scripts for, 15.5.1
- exporting metadata in Warehouse Builder client, 15.3.3
- exporting metadata, about, 15.3
- importing metadata in Warehouse Builder client, 15.4.4
- importing metadata, about, 15.4
- importing metadata, modes, 15.4.4.1
- importing, validation rules, 15.4.3
- log files, 15.2.2
- metadata matching criteria, 15.4.4.2
- results, 15.2.2
- snapshots, using with metadata import, 16.10.1
- metadata loader (MDL)
-
- overview of MDL, 15.1
- metadata snapshots
-
- cascade snapshot, defined in glossary, Glossary
- Microsoft Windows operating systems
-
- flat files residing on, 4.4
- minus
-
- in the Set Operation operator, 8.20
- mixed levels of aggregation, 3.9.1.3
- modes
-
- business name mode, 2.6.2.1.1
- ending read/write mode, 2.4.1
- logical name mode See business name mode
- naming mode, default, 2.6.2.2
- physical name mode, 2.6.2.1.2
- read-only mode, 2.4.2
- read/write mode, 2.4.1
- modules
-
- configuring warehouse modules, 5.3
- database source modules, about, 4.2
- defining SAP objects, 21.2
- flat file modules, about, 4.4
- module, defined in glossary, Glossary
- process flow modules, 10.1.1
- SAP application, 21.2.1
- source modules, 4.1
- multiple user account system, 2.2, 2.2.1, 2.2.1.3
- multiple-record-type flat files
-
- master-detail structure, 8.11.6
- master-detail structure, example of, 8.11.6
- multiple-table insert, 8.22.1, 11.1.3.5, 11.1.3.5
- multiple-user access
-
- about, 2.4
- ending read/write mode, 2.4.1
- folder-in-use locks, 2.4
- read-only mode, 2.4.2
- read/write mode, 2.4.1
- synchronizing changed objects, 2.4.3
- write locks on objects, 2.4
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
- See also primary keys
- synchronization
-
- synchronization vs. reconciliation, 6.7
- synchronizing
-
- automatic synchronization, 2.4.3
- changes to objects, 2.4.3
- on command, 2.4.3
- syntax
-
- for business object names, 2.6.2.1.1
- for logical object names, 2.6.2.1.1
- for physical object names, 2.6.2.1.2
- SYSDATE
-
- in the Data Generator operator, 8.4.2
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