Kansas City Oracle User's Group

Home Meetings
Officers
Events
Forum
Tuesday, April 23,2002
Meeting Location
5:45 p.m. - 7:45 p.m.
Black & Veatch
11401 Lamar Building P
Overland Park, Kansas

Guest Speaker
Chris Claterbos, Vlamis Software Solutions, Inc

Abstract:
With the use of the new features found in Oracle's Warehouse Builder (OWB) 3i and Oracle9i, we can now design, construct and load a data warehouse that is fully OLAP ready. This presentation introduces the attendee to OWB 3i and Oracle9i OLAP and how to design and construct an Oracle9i database that can be used for OLAP analysis and presentation. Design and implementation issues are also addressed. A step-by-step guide is 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
Download Materials
Meeting Agenda
Powerpoint Presentation


Directions
  • From Metcalf - Go East on College Blvd to Lamar. Go South on Lamar. It is the second building on the left or East side.
  • From I-435 - Take the Nall exit. Go South on Nall to College. Go West on College to Lamar. Go South on Lamar. It is the second building on the left.
  • Enter on the ground floor on the North side of the building. NOTE: This is marked as an employee entrance, but a guard will be able to direct you to the meeting location.




    		•