Monday Jul 27, 2015

EPM 11.1.2.x - Populating Today’s Date in Planning/PBCS with a Business Rule

In a previous CEAL blog, we have discussed how to calculate dates in Planning/PBCS:

As discussed in that blog, for dates in Planning/PBCS, Essbase stores the date as a numerical value e.g. a Start Date of 21st May 2015 would be stored as 20150521.

In a non-Planning/PBCS Essbase database, date functionality exists using the number of seconds elapsed since midnight, January 1, 1970 i.e. a non-numerical format different to the way Planning/PBCS stores dates to display on web forms.

It is possible, however, to use the Essbase date format and then convert that date into a Planning/PBCS format for use on a web form in order to populate a Planning/PBCS date member with today’s date i.e. the system date.

[Read More]

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]

Friday May 22, 2015

Zero Based Budgeting (ZBB) Considerations within Hyperion Planning

Zero based budgeting (ZBB) applications are becoming increasingly popular as a way to develop a budget, especially for lower growth organizations that are interested in cutting costs. The most significant difference between ZBB applications and traditional budget applications are the level of details captured. Where traditional budgeting applications plan an expense item directly or using a price X quantity formula, ZBB applications will plan every line item related to that expense. For example, when budgeting supply expenses, a ZBB application will include values for each detailed line item, including pencils, pens, paper clips, etc. Given the level of detail required for ZBB applications, careful consideration needs to be taken in order to have optimal performance within Hyperion Planning

[Read More]

Friday Feb 06, 2015

Financial Management

The new Oracle EPM System was released recently and it has some great enhancements especially for Financial Management. As one can see from the new Support Matrix (, Financial Management is available on the Exalytics platform now.
[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]

Monday Jan 05, 2015

OBIEE 11.1.1 - Tuning Guide Script v1

The obiee tuning guide available here lists a number of checks for optimization.

The script attached here automates these checks. It is only reading from the obiee server and it will not modify any values. The script outputs the current values, that you can compare with the recommended ones.

[Read More]

Tuesday Nov 18, 2014

Adding trim functions to the column expressions in ODI

When OBIA adaptors extracts data from PSFT source, the data can be padded with spaces. The PSFT system stores the data in db with padded spaces and when it is taken across OBIA warehouse without applying trim function in the ODI maps, the warehouse will also have the data with padded spaces. Blog gives an example of how to fix these type of issues at the implementation time.

[Read More]

Monday Nov 17, 2014

EPM - Enable HFM Thin Driver on Exalytics server

In EPM, FR web is deployed on Exalytics server enable the HFM thin driver by setting "UseHFMThinDriver" to “true” in jconsole ( Once enabled then restart all the services on Exalytics and HFM services on Windows. is located under:  <Middleware_Home>/EPMSystem11R1/products/financialreporting/bin

Thursday Oct 16, 2014

Getting started with Weblogic Scripting Tool for OBI

This white paper will guide you setting up a development environment, get you started with basic script writing, and point you to useful documentation. We will focus on the interactive and script mode, for embedded mode, please refer to the documentation for examples about instantiating the WLST interpreter in your Java code and using it to run WLST commands and scripts.
[Read More]

Saturday Sep 20, 2014

Exalytics OVM 3.2.x - Increase Send Queue Length (txqueuelen) for VM guest (DomU) VIF

For VM guest (DomU) VIF interface, by increasing the Send Queue Length (txqueuelen) from 32 or 500 to 10000 can increase network performance 50%.

a. How to Increase Send Queue Length in Dom0:

In Dom0, you need to perform following permanent changes to make the txqueuelen to 10000:
1. Run below ifconfig script by crontab and it will automatically set 10000 for all the VIFs:
ifconfig | grep -P '^vif\d+\.\d+' |  awk '{system("ifconfig "$1" txqueuelen 10000")}'

2. Edit /etc/rc.local and append the following setting per interface:
ifconfig eth0 txqueuelen 10000
ifconfig eth1 txqueuelen 10000

3. It is recommended to perform sanity check that txqueuelen is set to 10000 for all the VIFs in Dom0 when VM guest (DomU) is restarted.

b. How to Increase Send Queue Length in VM Guest (DomU):

In VM guest (DomU), you need to perform following permanent changes to make the txqueuelen 10000:
1. Edit /etc/rc.local and append the following setting eth0 interface only:
ifconfig eth0 txqueuelen 10000

2. It is recommended to perform sanity check that txqueuelen is set to 10000 for eth0 interface when VM guest (DomU) is restarted.

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]

Thursday Jul 17, 2014

Configuring OBIEE with Full End to End SSL

What do we need to configure SSL:
1. CA Root Certificate
2. CA Intermediate Certificate (if exists)
3. Java Keystores :: Identity Keystore and Trust Keystore
4. OBIEE Server Certificate
5. If External LDAP Directory like Oracle Internet Directory running in SSL
   OID Server’s CA Root Certificate
   OID Server’s CA Intermediate Certificate (if exists)
   OID Server Certificate

[Read More]

Tuesday Jul 15, 2014

OBIEE 11.1.1 - In case of Firewalls, OBIEE Scheduler may fails to Restart via OPMN or during BI configuration


If you have Firewall between OBIEE Server and Oracle Database machine, the OBIEE Scheduler component may fails to restart via OPMN or during BI configuration.

The firewall is setup with 'Urgent Flag'. As per firewall documentation, the Urgent Flag cannot be disabled. It is a global setting and would affect all traffic going in and out in organization. So the issue can be resolved by setting DISABLE_OOB=ON in the SQLNET.ora for BI Scheduler.

The firewall is clearing this Urgent Bit in the communication, the message is not transferred from the Scheduler (DB Client) to the Oracle database so by setting DISABLE_OOB=ON the Urgent flag is not sent from Scheduler and the connection works normally.

How-to: On BIServer side only, set DISABLE_OOB=ON in SQLNET.ora file > …/Oracle_BI1/network/admin

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]