Sunday Jun 28, 2015

EPM 11.1.2.x Essbase - DATAEXPORT calc command and CALCLOCKBLOCK/LOCKBLOCK

All dynamic member calculations, whether in an outline member formula or a business rule or calc script, will be calculated using the CALCLOCKBLOCK DEFAULT setting.

[Read More]

Tuesday Feb 03, 2015

EPM 11.1.2.x - Binding Host Name to have Essbase bind only to the IP address

Specify a Binding Host Name to have Essbase bind only to the IP address for the specified Binding Host Name. Otherwise, at startup, Essbase binds on all available IP addresses.

In EPM / releases, use "ESSBASESERVERHOSTNAME server_name" that identifies the host where your Essbase application process runs. The value must be a valid host name and must map to an IP address assigned to the computer. If ESSBASESERVERHOSTNAME is not specified in essbase.cfg, Essbase and the applications listen on all interfaces (IP_ANY).

For details on this refer to Essbase Tech Ref

In EPM release, in Configure Essbase Server specifies the host name (in Binding Host Name field) to which Essbase Agent and Essbase Server bind and where an Essbase application process runs.

For details refer to

Friday Jan 30, 2015

Essbase BSO Parallel Calculation and Calculator Cache

Essbase BSO parallel calculation utilizes calculator cache on a per thread basis. This post is to show the relationship between using parallel calculation and calculator cache.


[Read More]

Tuesday Sep 09, 2014

Using the @CURRMBR Function

Using the @CURRMBR Function

Essbase provides a suite of calculation functions to facilitate the definition and development of complex member formula calculations. The @CURRMBR calculation function is especially useful with scoping and managing complex calculations. The @CURRMBR (dimension) function is used to return the name of the member currently being calculated in the specified dimension.

[Read More]

Friday Jul 11, 2014

Essbase Outline Rebuilding vs. Migrating After Major Release Upgrade

The Essbase Readme document has been updated to include a change in recommendation with regard to rebuilding versus migrating the Essbase outlines between major release upgrades.  This represents a change in the upgrade process to ensure outlines take advantage of any new structures, features and functionality introduced in the major release.

[Read More]

Tuesday Apr 22, 2014

Error Connecting to Planning Application from Smartview

When the OU of a user is changed in the external provider, users can potentially have issues connecting to Planning applications from Smartview. However, users can still log into Planning just not Smartview. [Read More]

Tuesday Jan 21, 2014

Essbase 11.1.2.x - Web Launched EAS Console jnlp

When using the web launched EAS Console with internet explorer (http://<servername>:10080/easconsole/console.html) for the first time , it is possible that you will be prompted to open, find or save the easconsole.jnlp.

[Read More]

Monday Oct 14, 2013

Essbase Best Practice: Essbase Security File Auto Backup Intervals

By default, Essbase will automatically backup the Essbase security file, Essbase.sec, every 300 seconds (5 minutes). Most customers find the frequency of the default backup interval overhead to be unnecessary given their security update needs. It is recommended to change the default setting before the “build” and “go-live” phases to have better Essbase.sec file backups proportionally spaced between backups and improve overhead.

[Read More]

Wednesday Sep 04, 2013

Essbase 11.1.2.x - Changing Essbase ODL Logging Levels

ODL (Oracle Diagnostic Logging) information is recorded for both the Essbase agent and the Essbase application server. The level of the logging that is recorded can be amended if required.

These are the 2 ODL logs for Essbase:

  • EssbaseAgentODLLogger is for the Essbase agent. This writes to the ESSBASE_ODL.log in MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/Essbase/Essbase
  • DefSvrLogger is for the Essbase application server (ESSSVR). This writes to the <appname>_ODL.log in MIDDLEWARE_HOME/user_projects/epmsystem1/diagnostics/logs/Essbase/Essbase/app/<appname>

The level of logging for these Essbase ODL logs is controlled by the logging.xml file.

[Read More]

Tuesday Jul 30, 2013

Disabling Implied Share for an Essbase Application

Implied share is the default behavior in Essbase where a data relationship is shared explicitly between parent and child members in the outline. Implied share occurs when a parent has a single child or a parent has only one child of many children that consolidates to the parent in an Essbase outline.

If you need to disable all implied shares in a given outline, there is an Essbase configuration setting that can be set in the Essbase.cfg file. As part of the supported steps, it is recommended to rebuild the outline after the IMPLIED_SHARE <ApplicationName> FALSE setting is in place. This post it to help the field where in certain situations rebuilding the outline may be challenging. There is a way to set an existing outline to have implied share disabled, however, there are risks associated with these steps and no guarantee the metadata and data implied share setting are in sync. If there are any issues after following the “unsupported” steps, Oracle Support will require that the supported steps be followed first.

[Read More]

Friday Jul 19, 2013

Performance issues after upgrading Essbase outlines from 11.1.1.x to 11.1.2.x

After upgrading Essbase from the 11.1.1.x to 11.1.2.x releases, run through your sanity tests, such as outline dimension build updates, data loads, calculations, queries, etc.  If you encounter any performance issues on the newer release of Essbase (for either ASO or BSO models) as compared to the previous release, rebuild the problematic outline on the current 11.1.2.x release.  It is possibly that the outline did not migrate properly during the upgrade process.  

Once you have rebuilt the outline, run through your tests again and if you still encounter performance issues, open an SR with Support.


Thursday May 16, 2013

EPM How-to Setup Essbase Clustering on Unix

The steps on how to setup Essbase clustering on the release has changed as compared to the previous releases.  This document goes through how to setup Essbase clustering on Unix on the EPM release.  The information provided in this document has been taken from the EPM Installation and Configuration Guide, which can be found here @

> Download the Essbase clustering on the release step by step document



Wednesday Apr 24, 2013

Essbase Aggregate Storage (ASO) - Incremental Outline Updates Triggers a Full or Light Outline Restructure

When performing incremental updates to an Essbase Aggregate Storage (ASO) outline, depending on the nature of the incremental updates, could trigger either a full or light outline restructure.

[Read More]

Thursday Jan 24, 2013

Merge Data Slices Before Copying an Aggregate Storage (ASO) Application

Merge Data Slices Before Copying an Aggregate Storage (ASO) Application

When performing an Aggregate Storage (ASO) application copy, it is necessary to merge all data slices first so that all data in the ASO application will be copied properly. The current Essbase documentation does not clearly state a merge of the data is required before running an ASO application copy. An update to the Essbase documentation will be done. However, you can find the documentation update in the current Essbase readme documentation. See the current Essbase readme documentation under Documentation Updates:

Wednesday Dec 19, 2012

EPM Architecture: Essbase

This week’s post will cover Essbase architecture with all its related components like Provider Services, Administration Services, Integration Services and Essbase Studio.

[Read More]