X

2. EPM

PBCS: For 17.08 and Higher - Understand Business Rules using Calc Manager Log Messages

Introduction Starting in PBCS 17.08, the Log Messages panel in Calculation Manager has been improved to provide better messaging in order to help identify and optimize business rule logic. This blog post is intended to provide the details of these improvements and how to best utilize Calculation Manager Log Messages. Background Log Messages are only provided after execution of business rules within Calculation Manager.  After execution has completed, a new tab “Log Messages” will...

Friday, October 6, 2017 | 2. EPM | Read More

A Simple Guide to HFM Java API

Oracle EPM 11.1.2.4 is available since quite a while now. A lot of customers have adopted this release and start looking into automating common tasks to further increase the user experience and lower the maintenance efforts. Using the Java API, common HFM tasks can be automated easily. This post will provide first steps to log into HFM and run a Consolidation using the Java API. In an earlier blog post, I described the 11.1.2.4 HFM Architecture. Some may remember, that one of...

Wednesday, July 19, 2017 | 2. EPM | Read More

Configuring SSL for EPM 11.1.2.3 & 11.1.2.4 Products

Author: veera.raghavendra.rao@oracle.com This blog is all about how to configure Full SSL for EPM Products. Current document contains all steps that are needed to configure EPM Products in single Node. Steps Include: WebLogic Server (Creation of jks keystores) Oracle HTTP Server : using Oracle Wallet Essbase Server : using Oracle Wallet IIS Server Enabling SSL for Java Applications using EPM Config Utility Configuring SSL enabled Database Configuring SSL enabled External LDAPDirectories...

Wednesday, September 21, 2016 | 2. EPM | Read More

EPM 11.1.2.x – Planning/PBCS Best Practices for BSO Business Rule Optimisation

1. Introduction This document is intended to provide best practices for Business Rule Optimisation for Planning and PBCS models. It will cover items which can be edited within the script only i.e. syntax. Essbase.cfg settings for on premises Planning will not be discussed in this blog. 2. Environment Setting Below are recommended Calculation Commands, which are the elements that instruct the business rule how to execute the calculations. SET UPDATECALC OFF turns off intelligent...

Thursday, April 28, 2016 | 2. EPM | Read More

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: https://blogs.oracle.com/pa/entry/calculations_using_dates_stored_in 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...

Monday, July 27, 2015 | 2. EPM | Read More

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. When running a DATAEXPORT calc script, it is possible to use SET LOCKBLOCK within the script. However, it may not be possible for this setting to be used for the entire export. With DATAEXPORTOPTIONS "DataExportDynamicCalc ON”, only stored blocks will use the SET LOCKBLOCK settingin the script (e.g. Set LOCKBLOCK...

Monday, June 29, 2015 | 2. EPM | Read More