Oracle Warehouse Builder 10g: Implementation Part II

Model multi-dimensional dimensions and cubes. Populate the Oracle database analytic workspace by using OWB. Build an Expert. Manage multiple named configurations. Debug your mappings using the Mapping Debugger. Use Oracle Spreadsheet Add-In Microsoft Excel to connect to your Oracle OLAP data source. Use OWB Change Manager to take snapshot versions of metadata, compare them, and restore them if necessary


Understanding Oracle OLAP Concepts and Technology

Benefits of using OLAP for end users and for information technology (IT) in general
Key advantages of Oracle OLAP
Main features of a dimensional model
Role of an analytic workspace in the Oracle database

OWB OLAP Modeling and Deployment

Use additional dimension-modeling capabilities –Value-based, ragged-level, skip-level hierarchies
Design the multi-dimensional modeling

Using Spreadsheet Add-In to Query OLAP Data

Use Oracle Spreadsheet Add-In in Microsoft Excel
Connect to your Oracle OLAP data source
Create OLAP queries
Use Excel features on OLAP data

Managing OWB Life-Cycle Changes

Use OWB Change Manager to take snapshot versions of metadata, compare them, and restore them if necessary
Use Metadata Dependency Manager to perform impact and lineage analysis

Using the Mapping Debugger

Initialize a mapping debugging session
Prepare the testing environment and test data
Set breakpoints and watch points
Run a test mapping
Evaluate the flow of data to detect mapping errors

Managing the Warehouse Builder Environment

Use OWB security management user interface
Manage deployment and loading in a variety of configurations

Creating Experts

Explain the benefits of Warehouse Builder Experts for novice users
Use the Expert Editor to define an Expert