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.
Fraud analysis using Oracle Business Intelligence EE and Oracle OLAP
Sales and marketing analysis using Oracle Application Express and Oracle OLAP
Ad hoc analysis using Microsoft Excel and Oracle OLAP
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