Recent Posts by Jane Story

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...

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...

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...

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...

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. For calc parallel and calculator (calc) cache: Calc Parallel specifies the number of threads per calculation execution Calc Cache is memory used per thread If your calculations contain, for example, CALCPARALLEL 9 and 5 users run this script, then (9 threads * 5 users) = 45 concurrentthreads will be used...

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. The reason this dialog box appears is because the jnlp files are not associated with a program. In order to proceed, you will need to save the file e.g. to your desktop. Navigateto the file’s location using windows explorer. Right click on the file, select...

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 writesto the <appname>_ODL.log...

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 Standard Profitability – Smart View Integration There is now Smart View integrationincluded within the HPCM Standard Costing user interface. This will provide a...

  In HPCM, users access the “Job Status” task area to view the status of submitted jobs/task flows. In 11.1.2.2.x, the task flow information viewed on these screens within HPCM is cached in order to provide better performance. A refresh occurs after each configured interval and new entries are shown after this interval. By default this interval is set to 1 minute in 11.1.2.2.x. However, this property is configurable and can be changed if required. Check your refresh interval by...