With the use of the new features found in Oracle’s Warehouse Builder(OWB) 9i and Oracle9i 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 Oracle9i OLAP and how to design and construct an Oracle9i 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.