Category: Scripts

May 19, 2019

It is good to hear the EPM Automate utility supports Mac OS starting from May, 2019. Previously, when scheduling automation jobs, we typically use EPMAutomate from a Windows system. If the server side is Linux or Mac OS, we would use Java or Groovy to call REST API to process automation jobs.   By supporting…

August 1, 2018

Under the EPM cloud umbrella, there are 5 products come with data management, including Planning and Budgeting Cloud Enterprise Planning Cloud Financial Consolidation and Close Cloud Profitable and Cost Management Cloud Account Reconciliation Cloud Data management allows users to map data and metadata from source to target. The cloud data management sometimes is called the…

July 20, 2018

  As we know, EPBCS / PBCS does a daily back during the Daily Maintenance time, and saves the file as Artifact Snapshot.   To set up the daily maintenance time, we can go to Tools to update the time.     But the downside of this daily backup process is, it will overwrite the…

November 5, 2017

  On October 27th, FCCS November 2017 Update got released. One of the awesome updates is we can do configurable calculations. Oracle mentioned that:   You can add your own custom calculations to the seeded default calculations for your applications. The system provides insertion points within the default consolidation process where you can include your…

October 19, 2017

  As we know that Oracle released Essbase Cloud Service in March 2017. Since Essbase is in Cloud, we are able to use MDX to query and manipulate the multidimensional data from cloud now.  I think it might be a good time to discuss MDX.   Let’s do a quick intro about MDX. Just in…

September 11, 2017

  When we start writing any calc scripts in calculation manager, typically, we will start with the SET commands, which is the housekeeping part. The SET commands are restricted to the certain scripts and make sure the script can run in a proper and efficient way. Today, I would like to go through the major…

May 5, 2017

  The on-premise FDMEE gives us an opportunity to use batch files to load data. We can store the data files to a batch folder, then define a batch to load the data files. The PBCS / EPBCS FDMEE, which is the EPM Cloud version, is a little bit different. I will discuss the EPM Cloud…

April 18, 2017

  While we are developing an application or supporting an application, sometimes we need to transfer backup files from one instance to the other. Based on different requirements, the backup files or snapshots could be part of the application or the entire application.   The Migration in PBCS / EPBCS is the on-premises Hyperion LCM….

March 30, 2017

  FDMEE offers a powerful extensibility framework by providing Jython and Visual Basic based scripting. Using the rich set of the API library, users can extend and customize the product to best fit their needs. FDMEE supports four types of scripts:   Import scripts – Executed as source files are imported. Uses Jython script only….

March 24, 2017

  We are in a transition stage, the EPM applications either are migrating from on-premises version to cloud or building in cloud directly. Even though more and more companies choose cloud as their primary solutions, there are still tons of on-premises applications out there.  Since I started as an on-premises technical consultant, I am still…