Category Archives: Essbase
OAC Backups Failing
One of the issues that can crop up with customer-managed OAC instances, is backups failing. I ran into this recently on of our instances. This wasn’t just affecting backups, but also patches. As you know, patches need to be applied by ourselves on customer-managed instances of OAC. So, it becomes frustrating when patching fails. The……
Simple Migrations on Essbase Cloud
OAC Essbase New Features (September ’18)
Essbase CLI and SSL
The examination into practical uses of Essbase in the cloud continues today, with a look at a peculiar issue that crops up with the Essbase Command Line Interface (cli). Have a look at an earlier post which briefly looks at using cli with Essbase here. Oracle highly recommends securing your OAC URLs with SSL certificates……
Essbase Cloud Streaming Issue
In our continuing look at how to work with Essbase cloud, I thought today we’d look at a peculiar problem that arises with the Essbase Command Line Interface (cli). First off, you may want to look at Suresh T’s excellent blog post on streaming data loads using the cli. In the post, Suresh outlines how……
Using Groovy Scripts on Essbase Cloud
Continuing on with my love-fest on Essbase Cloud, I wanted to explore another little trick that the nice folks at Oracle have shipped with OAC. Specifically, the ability to run Groovy scripts from Essbase Cloud. The first clue that this is possible, comes from the “Jobs” tab. Well that’s great, but how do we get……
Essbase Cloud Features II
Carrying on in our series about new features on Essbase Cloud, I wanted to take a look at some of the other features that are now available in the so-called Modern interface. Specifically, the “Analyze” and “Inspect” features. First off, if you wanted to toggle between the “Classic” (not sure why you would want to,……
Essbase Cloud Features I
Essbase Cloud CLI on Macs
After a bit of a break, I thought I’d change track on some of the things I’ve been posting about recently, and look at some of the functionality offered by Essbase Cloud. Specifically, as it relates to working with the Essbase Command Line Interface (CLI). There are many excellent examples on using this tool on……
Data Exports and ODI
ODI, the Essbase API and Jython I
Through this blog, we’ve been trying to advertise the fact that the tools we have at our disposal go a long way towards creating user-friendly solutions. Today, I thought I’d delve into the world of the Essbase API. Further, I thought we’d explore how the API can work, with Jython, and by extension, ODI. There……
Export Essbase Substitution variables to SQL
Part 1: Essbase and Hyperion Planning Outside-the-box
Welcome to Part 1 of a multi-part series detailing the creation of some out-of-the-ordinary processes leveraging Hyperion Planning command-line utilities, new (and old) Essbase CDFs and Hyperion Planning back-end repository tables. In this series, we will look at a requirement that arose at a recent client requiring the ability to update security within a Planning……
Hyperion Calc Manager validation versus EAS validation (RUNJAVA)
While working with the @CalcMgrExecuteMaxLScript Essbase CDF I came across some intricacies around using the RUNJAVA flavor of this CDF (RunJava com.hyperion.calcmgr.common.cdf.MaxLScriptFunction). I was developing some calc scripts in EAS with the intention of converting them to Calc Manager calculation rules for use with Hyperion Planning. I find the script editor in Calculation Manager to……