Oracle OLAP

Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 12c. 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 12c, 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.

Oracle BI Enterprise Edition Image Oracle Application Express
Fraud analysis using Oracle Business Intelligence EE and Oracle OLAP Sales and marketing analysis using Oracle Application Express and Oracle OLAP
Oracle Application Express
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

Tutorials

Oracle OLAP 12c (also compatible with 11g)
red-arrow-box Building OLAP 12c Cubes
red-arrow-box Querying OLAP 12c Cubes
red-arrow-box Using Microsoft Excel With Oracle 12c Cubes
red-arrow-box Creating BI EE Metadata for OLAP 12c Cubes
red-arrow-box Querying OLAP 12c Data Using Oracle BI Answers
red-arrow-box Creating Interactive APEX Reports Over OLAP 12c Cubes

   
 

Technical Information

Oracle OLAP 11g
red-arrow-box Oracle OLAP 11g Release 2 Datasheet
red-arrow-box Oracle OLAP 11g Exadata X2-2 Performance Demonstration
red-arrow-box On-line Analytic Processing with Oracle Database 11g Release 2
red-arrow-box Creating an Oracle BI Presentation Layer from OLAP Cubes
red-arrow-box Troubleshooting Oracle BI EE Connections to OLAP
red-arrow-box Developing Analytic Workspace Manager Plug-ins 11g

Demonstrations & Videos
red-arrow-box Oracle OLAP Overview - Part 1: Architecture (view)
  Oracle OLAP Overview - Part 2: Key Features (view)
  Oracle OLAP Overview - Part 3: Use Cases (view)
red-arrow-box Creating Cubes: Part 1 - Concepts ( view | download to iPod)
red-arrow-box Creating Cubes: Part 2 - Using AWM ( view | download to iPod)
red-arrow-box Using Excel with Oracle OLAP
red-arrow-box Create BI EE Metadata Over Cubes in Minutes
 
Download
red-arrow-box Analytic Workspace Manager
red-arrow-box  AWM Plug-in
red-arrow-box  OLAP DBA Scripts
red-arrow-box  Sample Code & Schemas
red-arrow-box Automatically Generate BI EE Metadata Over OLAP Cubes ( download | readme | video)

Learn More
red-arrow-box Documentation: 11g 
red-arrow-box Oracle by Examples: 11g
red-arrow-box Oracle Education OLAP Courses
red-arrow-box Product Discussion Forum
red-arrow-box Oracle OLAP Blog
red-arrow-box Oracle OLAP Wiki
red-arrow-box Recommended Releases
   
 
Related Technologies
red-arrow-box Oracle BI Home
red-arrow-box Oracle Database BI Features
red-arrow-box Oracle Data Mining
   
red-arrow-box Oracle BI DW Technology Center
red-arrow-box Oracle Statistical Functions
red-arrow-box Oracle JDeveloper
red-arrow-box Oracle Warehouse Builder

In-Memory Replay Banner