Oracle OLAP

Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 11g. Oracle OLAP cubes deliver sophisticated calculations using simple SQL queries - producing results with speed of thought response times. This outstanding query performance may be leveraged transparently when deploying OLAP cubes as materialized views – enhancing the performance of summary queries against detail relational tables. Because Oracle OLAP is embedded in Oracle Database 11g, it allows centralized management of data and business rules in a secure, scalable and enterprise-ready platform.

Oracle OLAP makes it easy to produce analytic measures, including time-series calculations, financial models, forecasts, allocations, regressions, and more. Hundreds of analytic functions can be easily combined in custom functions to solve nearly any analytic calculation requirement. Oracle OLAP cubes are represented using a star schema design: dimension views form a constellation around the cube (or fact) view. This standard representation of OLAP data makes it easy for any reporting and analysis tool or application - including sophisticated business intelligence solutions, SQL-based development tools and Microsoft Excel - to leverage the power of Oracle OLAP in a simple and productive way.

With Oracle OLAP you can:

• Easily define a multidimensional model with advanced analytic calculations
• Productively deliver rich analytics to any reporting and analysis tool using simple SQL
• Transparently improve summary queries against tables using cube-based materialized views
• Combine OLAP data with any other data in your Oracle Database - including spatial, data mining, XML, documents and more
• Leverage your existing Oracle Database expertise and software investment