With the use of the new features found in Oracle’s Warehouse Builder (OWB) 3i 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 3i and Oracle 9i OLAP and how to design and construct an Oracle 9i database that can be used for OLAP analysis and presentation. Design and implementation issues will also be addressed. A step-by-step guide will be presented with the end result being an OLAP-ready datamart.

Topics Include:

• New Features of OWB 3i

• Overview of OLAP Features of Oracle 9i

• Designing a Multidimensional Database with OWB

• CWM Metadata in 9i

• Designing the Datamart

• Updating the 9i Metadata

• Loading and Viewing Data

• Design and Implementation Issues