The Oracle OLAP option is a full-featured on-line analytical processing (OLAP) server embedded within the Oracle Database. The Oracle OLAP option can be used to improve SQL- based business intelligence tools and applications by improving query performance and enriching them with analytic content. As an OLAP solution that is deeply embedded in the Oracle Database, the Oracle OLAP option allows centralized management of data and business rules in a secure, scalable and enterprise-ready platform New in Oracle Database 11g is support for OLAP-based materialized views which can replace the need to replace, perhaps thousands of materialized views into a single, easy-to-manage.
