Oracle 9i OLAP enables all Oracle data warehouses and data marts to be analyzed with OLAP applications. In Oracle 9i, Oracle has separated the physical storage of data warehouse data from the logical analysis of OLAP applications. This eases the whole process of developing applications. More importantly, it opens up previously inaccessible data to new business applications. How do we now capitalize on these new capabilities?

What’s the magic that makes this work? How does this impact performance? What operations are precluded by various design decisions? Why would you want to use Oracle 9i OLAP or BI Beans instead of simply using regular RDBMS tables with Oracle Discoverer?

This presentation will describe the components of Oracle 9i OLAP. Armed with information such as “what is an analytic workspace”, and “what metadata is required to support the Java OLAP API and BI Beans?”, a designer will be able to design a data warehouse or data mart for use by a business intelligence application. In addition, a manager will understand what options are possible and how to gain maximum value from a data warehouse or data mart.