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.
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
Oracle OLAP 11g
- Oracle OLAP 11g Release 2 Datasheet (PDF)
- Oracle OLAP 11g Exadata X2-2 Performance Demonstration (PDF)
- On-line Analytic Processing with Oracle Database 11g Release 2 (PDF)
- Creating an Oracle BI Presentation Layer from OLAP Cubes (PDF)
- Troubleshooting Oracle BI EE Connections to OLAP (PDF)
- Developing Analytic Workspace Manager Plug-ins 11g (PDF)
Demonstrations & Videos
- Oracle OLAP Overview - Part 1: Architecture (view)
- Oracle OLAP Overview - Part 2: Key Features (view)
- Oracle OLAP Overview - Part 3: Use Cases (view)
- Creating Cubes: Part 1 - Concepts ( view | download to iPod)
- Creating Cubes: Part 2 - Using AWM ( view | download to iPod)
- Using Excel with Oracle OLAP
- Create BI EE Metadata Over Cubes in Minutes
Download
- Analytic Workspace Manager
- AWM Plug-in
- OLAP DBA Scripts
- Sample Code & Schemas
- Automatically Generate BI EE Metadata Over OLAP Cubes ( download | readme | video )
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 |
|---|---|---|---|
| 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