Posts Tagged ‘Oracle PBCS’

Setting up Daily Replication Script for PBCS applications

One of the things that organizations tend to want or need during and after an implementation are application refreshes. In this blog post, I have two environments, PROD (Source) and TEST (Target), which I have developed a script to facilitate end users to refresh TEST environment. This script should be run where EPMAUTOMATE was installed […]

EPBCS – Performance Load Testing Using EPM Automate and HAR

EPBCS Performance is another key area which we focus on our Planning Projects during UAT. Oracle recommends to use HAR files to track the steps executed by users in Smartview or business rules executed from planning data forms. Oracle recommends to install Fiddler tool to create these HAR Files. EPM Automate has a replay command which can […]

Integrate Oracle Database with EPBCS using Rest API

EPBCS uses a Lighter version of FDMEE Data Management to load the external data into application. Most of the EPBCS Implementation use File method to load the data, Hyperion Admin need to request the data in a delimited format file with fixed columns. Sometimes the turn around time for getting the file may be longer than expected or the Admin may […]

Automation of FDMEE Jobs using EPM Automate in EPBCS

  Introduction: Oracle EPM cloud has set of EPM Automate commands which are used to automate administration process for EPBCS. Admins can write batch scripts on MS-Dos, PowerShell or other batch scripting program to call the EPM Automate commands. Batch scripts can also be scheduled using Task Scheduler in Windows. This blog is for the […]

EPBCS – Rules usage report and adding data to suppressed rows

Oracle is doing a great job in continuously upgrading the PBCS / EBPCS based applications. Being a EPBCS consultant I always follow their latest updates to make sure we use it in our implementation or support process. This Blog is specific to two recent update which is really useful Below is the link for Oracle EPBCS latest update release : […]

Invoke Business Rule Using EPBCS REST API in Groovy – Part 1

EPBCS REST API REST (Representational state transfer) API is a method to interact with the server using an HTTP request. The user sends an HTTP request and the server responds to the request in JSON Format. Before the REST API, the server used to send an xml response, which is processed on the client side, […]

Updating Substitution variables using EPM Automate

EPM Automate EPM Automate is always my one of the favourite topic when it comes to blogging. I don’t see EPM Automate as just a bunch of scripts which reduces some manual task done by users/admins but it also helps in troubleshooting, running reports and much more. This is my 4th blog in EPM Automate […]

Dynamic Creation and Deletion of Members in PBCS/EPBCS

Introduction PBCS/EPBCS has the option of deleting and creating a member for Dimension without doing any refresh to the database. This feature was introduced later in on-Premise planning application and the same is available in PBCS/EPBCS. We had instances where user had to wait for sparse dimension members to get added by admin and then […]

Success Story: Oracle PBCS is Just What the Doctor Ordered

Our client is a leading healthcare provider with 13 clinical departments, each with multiple entities and varying degrees of complexity. They implemented Hyperion Planning in 2012 and experienced significant growth since then as a result of expansion into the community and in their main campus. There was a growing need to provide the executive office […]