219: Building Cubes and Analyzing Data Using Oracle OLAP 11g
Chris Claterbos , Vlamis Software Solutions, Inc.    Biography

Objectives: Demonstrate What 11g OLAP can do for Data Warehouse
Show that adding OLAP to existing relational warehouses is easy and very powerful
Migrating from 10g to 11g is safe and easy
Abstract: Can I move my existing "multi-dimensional cubes" to 11g? Can I really improve my warehouse performance using OLAP? What is the benefit of upgrading to OLAP 11g? Do you need those "analytic workspace" things if you're going to use Oracle Business Intelligence? And can Oracle BI really generate more efficient SQL than you? This presentation will demonstrate the process of migrating 10g cubes and dimensions to 11g and using Oracle OLAP 11g to create cubes and analyze data. There will be a practical look at the new features of OLAP 11g and what it means to the Warehouse Architect and Users. OLAP 11g adds a lot of new features designed to help the DBA and Architect build multidimensional warehouses rapidly and integrate them seamlessly into the relational model. This presentation will help a DBA prepare a database and design schemas for use by SQL and OLAP applications and help an application developer understand what options are possible and how to gain maximum value from a data warehouse

Audiernce Focus: Managers
Expertise: Intermediate
Track: Business Intelligence/Warehousing
Date: Tuesday, April 15, 2008
Time: 3:30 PM - 5:45 PM