Installing Essbase with Oracle Business Intelligence

You can install Essbase when you install Oracle Business Intelligence.

When you install Essbase with Oracle Business Intelligence, Essbase databases become available to Oracle Business Intelligence users, and you can manage Essbase components using a combination of Oracle Business Intelligence tools and Essbase EPM System tools. For information about which version of Essbase is installed, go to the Certifications page in Oracle Support and check the product details for appropriate releases of Oracle Business Intelligence Enterprise Edition with Oracle Essbase at:

https://support.oracle.com

Note:

You cannot add Essbase to an existing Oracle Business Intelligence installation although you can still use Essbase as a data source. The only way to install Essbase with Oracle Business Intelligence is to perform a new Oracle Business Intelligence installation and select the Essbase component.

You install EAS and Studio using the EPM installation. See the EPM guides for more details.

This topic contains the following sections:

Installing Essbase

You install Essbase Suite as part of an Oracle Business Intelligence Enterprise installation.

For more information, see Installing and Configuring Oracle Business Intelligence.

The Enterprise Install type creates and configures a single WebLogic Server Domain that contains a cluster with an Administration Server, and a Managed Server. If you select Essbase Suite during the install, then Essbase JEE components and Oracle Business Intelligence JEE components are installed on Managed Servers. For information, see Selecting the Essbase Suite Option During Install.

Selecting the Essbase Suite Option During Install

You can install JEE applications and services during install.

Selecting the Essbase Suite option during the install does the following:

  • Pre-selects the Oracle Business Intelligence Enterprise Edition option.

  • Installs the following Essbase-related JEE applications and services into the local Oracle BI EE Managed Server in an Enterprise Install:

    • Essbase Agent

    • Cube Deployment Services

    • Hyperion Provider Services (APS)

  • Installs the following Essbase server processes:

    • Essbase App.

  • Enables you to download the following Essbase-related client applications from the Download BI Desktop Tools option, which is available in the Get Started area of the Home page for Oracle BI EE:

    • Smart View for Office (EPM application)

    For more information, see "Downloading BI Desktop Tools" in User's Guide for Oracle Business Intelligence Enterprise Edition.

  • Enables users to log in to the following Essbase command line tools:

    • ESSCMD

    • ESSMSH (MaxL)

  • Enables users to log in through the following supported Essbase API languages:

    • JAPI

    • C-API

      Note:

      Client applications and API languages that are not included in this section are not supported with Essbase and related components installed with Oracle Business Intelligence.

Limitations for Using Client Tools when Essbase Is Installed with Oracle Business Intelligence

There are limitations for using the following Essbase tools when Essbase is installed with Oracle Business Intelligence.

  • MaxL command line interface

    The MaxL command line supports most of the tasks for Oracle Business Intelligence Essbase that are also possible with Oracle EPM System Essbase.

    Note:

    You cannot use the MaxL command line to provision security.

Essbase Features Not Supported when Essbase Is Installed with Oracle Business Intelligence

When Essbase is installed with Oracle Business Intelligence, you do not get a full Enterprise Performance Management installation.

The following Essbase features are not supported:

  • Permission grants are not supported at the database level. For example, if you have two multidimensional databases that are used by an application, then permission grants apply equally to the multidimensional databases in an application.

  • Multiple clusters are not supported.

  • The Active-Active failover process is not supported. You can have only one machine or cluster active at a time, and you cannot load balance across computers or clusters.

  • The audit report showing what users, groups and application roles can do in Essbase, when Essbase is installed as part of an Enterprise Performance Management System, is not available in this release. However, you can use Oracle Fusion Middleware Control to view the Essbase permissions assigned to application roles.

  • There might be other Enterprise Performance Management features that are not supported when Essbase is installed with Oracle Business Intelligence. To avoid misunderstandings, do not use EPM System or Essbase documentation (when Essbase is installed with Oracle Business Intelligence), unless directed to do so in this documentation.