With the use of the new features found in recently updated Oracle’s Warehouse Builder (OWB) and Oracle 9i/10g we can design, construct and load a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 10g and Oracle OLAP and how to design and construct a Oracle 10g database that can be used for OLAP analysis and presentation. The many new features that improve on the ability to build OLAP warehouses taking advantage of the many new features in Oracle 10g will be presented. 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.