Wednesday Oct 16, 2013

EPM Infrastructure Tuning Guide v11.1.2.2 /

Applies To: This edition applies to only,

One of the most challenging aspects of performance tuning is knowing where to begin. To maximize Oracle EPM System performance, all components need to be monitored, analyzed, and tuned. This guide describe the techniques used to monitor performance and the techniques for optimizing the performance of EPM components.


Performance tuning Oracle Hyperion EPM system is a complex and iterative process. To get you started, we have created a list of recommendations to help you optimize your Oracle Hyperion EPM system performance.

This chapter includes the following sections that provide a quick start for performance tuning Oracle EPM products. Note these performance tuning techniques are applicable to nearly all Oracle EPM products such as Financial PM Applications, Essbase, Reporting and Foundation services.

1. Tune Operating Systems parameters.
2. Tune Oracle WebLogic Server (WLS) parameters.
3. Tune 64bit Java Virtual Machines (JVM).
4. Tune 32bit Java Virtual Machines (JVM).
5. Tune HTTP Server parameters.
6. Tune HTTP Server Compression / Caching.
7. Tune Oracle Database Parameters.
8. Tune Reporting And Analysis Framework (RAF) Services.
9. Tune Oracle ADF parameters.

Click to Download the EPM Infrastructure Tuning Whitepaper (Right click or option-click the link and choose "Save As..." to download this pdf file)

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]

Thursday Sep 26, 2013

EPM Client cert authentication

If you are planning to use client cert authentication against EPM (, there are a few additional elements to consider on top of the documentation[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]

Wednesday Aug 21, 2013

Grid Diagnostics Replaces MassGridStatistics

An earlier blog entry,, discussed the Planning MassGridStatistics utility for displaying web form load times. Starting with the release, MassGridStatistics has been replaced by the grid diagnostics functionality located with the Planning web interface.

[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 Jul 18, 2013

HFM / OBIEE Integration using the new ADM thin driver

For details on configuration steps on-how to perform HFM / OBIEE Integration using the new ADM thin driver, download this pdf document.



OBIEE cluster web SSO - ADFS IdP SAMLv2

We posted how to configure OBIEE for SSO using SAML and ADFS , on a single node previously --> there:

This post describes  how to perform the same, but with a clustered OBIEE deployment. The main change is regarding the necessary use of aWeblogic RDBMS security store to cache SAML assertions across nodes, as well as the configuration of the load balancer.[Read More]

Tuesday Jun 18, 2013

Importing server and private key in Oracle wallet

You want to create a wallet containing your server cert and private key provided by your PKI administrator as a yourcert.p12 file.

Use keytool and orapki. But make sure your wallet and the private key passwords match.

[Read More]

Tuesday Jun 11, 2013

Highlights of HPCM New Features

The latest release of HPCM provides several new features as well as performance improvements.

V11.1.2.3 provides the following:

  • Standard Profitability – Smart View Integration
  • Detailed Profitability – new calculation rules
  • Detailed Profitability – Essbase Integration
  • Detailed Profitability – Stage Balancing Report
[Read More]

Monday Jun 03, 2013

Highlights of Planning New Features

The latest release of Planning includes several performance improvements as well as some new features not present in earlier releases. Some highlights of the new features include:

  • “Member on the Fly” functionality – For Workforce Planning, Capital Asset Planning, Project Financial Planning and Public Sector Budgeting customers, Planning offers “member on the fly” functionality where end users can dynamically add sparse dimension members and use the added members on a form without performing a Planning refresh. The administrator determines how many new members can be added prior to the next regularly scheduled refresh. Below is an example on how to the “member on the fly’ functionality can be implemented:
[Read More]

Monday May 27, 2013


[Read More]

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]