With the use of the new features found in Oracle’s Warehouse Builder(OWB) 9i and Oracle 9i we can now design, construct and load a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 9i and Oracle 9i OLAP and how to design and construct an Oracle 9i database that can be used for OLAP analysis and presentation. The new OWB API will also be presented as well as the new OLAP migration wizards. Implementation and design issues will also be addressed. A step-by-step guide will be presented with the end result being a completed OLAP based datamart. A complete End-to-End demonstration will be presented.

Outline:

1. New Features of OWB

2. Overview of OLAP features of Oracle 9i

3. Designing a Multidimensional Database with OWB

4. Designing the Datamart

5. Updating the 9i Metadata

6. Loading and Viewing Data

7. Managing with OEM and AW Manager

8. Using the OWB 9i API

9. Issues with Design and Implementation

10. Viewing the Data

Accompanying paper is available at http://vlamiscdn.com/papers/oraworld2003-paper1.pdf