Analytic Workspace Manager and Oracle OLAP 10g
Designing and implementing the dimensional model is one of the core activities of building a business intelligence application. The OLAP Option to Oracle Database 10g is the OnLine Analytic Processing (OLAP) server for business intelligence. Analytic Workspace Manager, the primary administrative tool of the OLAP Option, provides users with the ability to design and manage collections of multidimensional data types in Oracle Database 10g. Analytic Workspace Manager is a tool in which the dimensional model can be defined, implemented, and managed throughout its lifecycle. This paper introduces some key concepts of the OLAP Option to Oracle Database 10g and the process of designing and implementing dimensional models.