OR418 Oracle Warehouse Builder (OWB) Part II

OVERVIEW

Oracle Warehouse Builder (OWB) instructs students in the use of the OWB toolset, to extract, transform and load data. This course is part II of the OWB training and covers more on the features of OWB and multidimensional model including cubes, online analytic processing (OLAP) and using spreadsheet Add-in to query OLAP data.

OBJECTIVES 

• Model multi-dimensional dimensions and cubes
• Populate the Oracle database analytic workspace by using OWB
• Manage multiple named configurations
• Debug your mappings using the Mapping Debugger
• Use OracleBI 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 

PREREQUISITES

Persons taking this class should have taken the Oracle Data Warehouse Builder I class or have working knowledge of the product.  Note the pre-requisites for the Part I class is a basic understand of Entity Relationship Modeling (ERD) and relational design concepts, SQL and PL/SQL programming and Data Warehousing concepts.  These classes are offered by ONYX. 

INTENDED AUDIENCE

Developers responsible for extract, transform and load processes using OWB

FORMAT

Lecture and discussion followed by hands-on lab workshops for each major topic to reinforce the material.  Each participant will receive an extensive lecture guide with several examples and workshop solutions.

CONTENT 

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
• Use value-based, ragged-level, skip-level hierarchies
• Design the multi-dimensional modeling

 Using Spreadsheet Add-In to Query OLAP Data

• Use OracleBI 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
• Use OWB Change Manager to, compare them, and restore them
• 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