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 11.1.2.4

The new Oracle EPM System 11.1.2.4 was released recently and it has some great enhancements especially for Financial Management. As one can see from the new Support Matrix (http://www.oracle.com/technetwork/middleware/bi-foundation/oracle-hyperion-epm-system-certific-131801.xls), 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 11.1.2.2 / 11.1.2.3 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 11.1.2.4 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 http://docs.oracle.com/cd/E57185_01/epm.1112/epm_install/essbaseAgentPortPanel.html


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 11.1.2.3 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]

Monday Jul 07, 2014

OLAP_MAX_CONNECTIONS Property Considerations

The OLAP_MAX_CONNECTIONS property controls the maximum number of connections from Planning to Essbase. The default setting is 10, but the property can be increased to allow for more concurrent Essbase connections. The Hyperion Planning Administrator’s Guide recommends a setting of 20 for 100 users and 100 for 500 users.


 

[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]

Friday Nov 22, 2013

Calculations Using Dates Stored in Planning

Planning allows users to enter date values in Planning. For example, a start date can be entered as 11/01/2013 if the format is MM/DD/YYYY. Although the values are entered in date format, it is possible to calculate values based on dates entered.


[Read More]

Thursday Sep 26, 2013

EPM Client cert authentication

If you are planning to use client cert authentication against EPM (http://docs.oracle.com/cd/E17236_01/epm.1112/epm_security_11121/frameset.htm?ch02s13s04.html), 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, https://blogs.oracle.com/pa/entry/planning_11_1_2_massgridstatistics, discussed the Planning 11.1.2.1 MassGridStatistics utility for displaying web form load times. Starting with the 11.1.2.2 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]