Introduction

Oracle Essbase is one of the industry-leading multi-dimensional online analytical processing (OLAP) servers, providing a rich environment for effectively developing custom analytic and enterprise performance management applications. By leveraging its self-managed, rapid application development capabilities, business users can quickly model complex business scenarios. For example, line-of-business personnel can simply and rapidly develop and manage analytic applications that can forecast likely business performance levels and deliver "what-if" analyses for varying conditions. Oracle Essbase supports extremely fast query response times for vast numbers of users, large data sets, and complex business models.

Connectivity

There are two ways for CXO_Cockpit to connect to Essbase. The architecture pictures below describe the two different ways for CXO-Cockpit to connect to Essbase.

OLAP Connector

The Hyperion Essbase - OLAP Connector uses a straight connection to Essbase. Data is always live, every CXO-Cockpit user needs to have an Oracle Hyperion Essbase license.

Application Adapter

With the Hyperion Essbase - Application Adapter data will be copied to SSAS. The data is not live. CXO-Cockpit users do not need an Oracle Hyperion Essbase license.

See Also

• Limit Metadata with MDX Filters
• Essbase Authentication Plugin

Installation Prerequisites

You can find the Installation Prerequisites file for Hyperion Essbase in this article.