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.
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:
Note: All OLAP Patches are cumulative (i.e. OLAP C Patch contains everything in B and A)
RDBMS Version | OLAP patch | Patch Description | Availability |
---|---|---|---|
12.1.0.2 | 29336632 |
|
|
12.1.0.1 | 17567822 | OLAP A Patch |
|
18826524 | AWM B Patch | OTN & MOS | |
11.2.0.4 |
|
|
Linux64,Solaris Intel , Sol SPARC, zLinux, AIX |
27423441 |
|
|
|
28576785 | OLAP F Patch - July 2018 patchset | Windows X64 | |
18520912 | AWM B Patch | OTN & MOS | |
11.2.0.3 |
|
|
|
21473387 | H Patch for Exadata BP 12-28 | Linux64 | |
|
|
| |
20638200 | H Patch for PSU 12 | HP-Itanium | |
17954813 | OLAP E Patch |
| |
11.1.0.7 | 20890888 | OLAP D patch plus for PSU 23&23 | Linux64, Solaris SPARC, HP-itan |
20480590 | OLAP D patch plus sec fix | AIX | |
9147749 | OLAP D Patch | Linux32, HP-UX, windows |
Last Updated: Feb 2019