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
