Thursday Apr 28, 2016

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.


[Read More]

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:

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

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 Nov 13, 2012

EPM 11.1.2.2 Architecture: Foundation

This post is the first of a series that is going to describe the EPM System architecture per component. During the following weeks a couple of follow up posts will describe each component. Shared Services, EPMA and Calculation Manager architecture are covered by this post.

[Read More]