Using Oracle 10g R2 and Oracle Warehouse Builder (OWB) Release 2 we can now design, construct, load and view data in a data warehouse that is fully OLAP ready. This presentation will introduce the attendee to OWB 10g Released2 and Oracle OLAP and show how to design and construct a Oracle 10g database that can be used for Business Intelligence. 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. Included in this presentation are Tips and Techniques that have been used over several projects to provide a fully functional Business Intelligence solution using one tool.