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.

BPM Learning Paths and Certification

Fraud analysis using Oracle Business Intelligence EE and Oracle OLAP

What's New in Oracle BPM Suite 12c (PDF)

Sales and marketing analysis using Oracle Application Express and Oracle OLAP

BPM Tutorials

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

Oracle Data Warehouse

Note: All OLAP Patches are cumulative (i.e. OLAP C Patch contains everything in B and A)

RDBMS Version OLAP patch Patch Description Availability 29336632
  • OLAP C+ Patch
  • Overwrite A & B, Exa 1-13, PSU 1-5 and through
  • Jan 2019 bundles
  • Nov 2019 patchset
  • Linux64, Sol Intel & Sparc, HP Itan, zlinux, AIX on Power
  • Windows X64 17567822 OLAP A Patch
  • Linux64, Solaris SPARC & Intel,AIX on Power, HP-Itan, HP-UX,and Zlinux
  • Windows Patchset 8
18826524AWM B PatchOTN & MOS
  • 29297389
  • 29227631
  • OLAP G Patch
  • Overwrite A-F, Exa BP 1-20, PSU 1-8 and through Jan 2019 bundles
Linux64,Solaris Intel , Sol SPARC, zLinux, AIX
  • OLAP F Patch
  • Overwrite A-E, Exa BP 1-20, PSU 1-8 and through January 2018 Bundles
  • HP Itan
  • Windows X64 April 2018 patchset
28576785 OLAP F Patch - July 2018 patchset Windows X64
18520912 AWM B Patch OTN & MOS
  • 19847256
  • 20470595
  • OLAP H Patch
  • OLAP H Patch +
  • Linux64, Sol SPARC
  • HP-Itan
  • Windows BP 41 (Nov 2015)
21473387 H Patch for Exadata BP 12-28 Linux64
  • 21480417
  • 21667344
  • H Patch for PSU 13-15
  • H Patch for PSU 7-15
  • Linux64
  • Sol SPARC
20638200H Patch for PSU 12HP-Itanium
17954813OLAP E Patch
  • Linux64, Solaris SPARC & Intel,AIX on Power, HP-Itan, HP-UX,and Linux32
  • Windows P29 20890888OLAP D patch plus for PSU 23&23Linux64, Solaris SPARC, HP-itan
20480590OLAP D patch plus sec fixAIX
9147749OLAP D PatchLinux32, HP-UX, windows

Last Updated: Feb 2019