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

Continue reading

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

Continue reading

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

Continue reading

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,……

Continue reading

Essbase Cloud Features I

That took a while!! Sorry for not posting sooner, but I’d been distracted with KScope for the last couple of months. We had 2 presentations (you can find the content here and here), and it was a blast. I thought today, I’d come up with a short post, introducing some cool new functionality that is……

Continue reading

Oracle Integration Cloud Service POST

I thought we’d look at another example of using OIC seamlessly with your EPM cloud integrations. Today, we’ll look at how to “POST” or submit updates to your PBCS application. In this case, we’ll be updating a substitution variable from OIC. The integration setup steps are similar to what we’ve done in previous posts (I……

Continue reading

Oracle Integration Cloud Service for EPM III

In this post, we will apply the finishing touches to our integration. You can find the earlier parts here and here. One of the things you also need to set up on your integration, is a tracking parameter. This is a mandatory step, and can be done from the Tracking page. I just used the……

Continue reading

Leverage the DRG Calculate Name and Calculate Parent features – Part 1

A long time ago (i.e. a little bit more than a year ago) I started playing with DRM and more specifically with the new DRG features that had just been added like Calculate Name and Calculate Parent, and so I had made a quick post about their availability and how to enable them and I……

Continue reading

Oracle Integration Cloud Service for EPM II

This post continues on from an earlier one, which can be found here. From a blank canvas, we can just drag and drop the REST connection from the Invokes palette on the right. On the wizard that opens up, you get the option to specify which REST command you would like to execute. To get substitution variables from……

Continue reading

Oracle Integration Cloud Service for EPM I

It’s been a while since my last post. So, I thought we’d look at something a bit different. Recently, I got my hands on an Oracle Integration Cloud instance. I wanted to see what it could do for EPM developers. While Oracle offers excellent videos on getting up to speed with the tool, it always……

Continue reading

Fun with Oracle DRM and JavaScript

Episode 1: PropDefObject Good day all! I thought I would start a new blog series detailing the different (Oracle DRM) Data Relationship Objects and how to work with them using the newer JavaScript option available for derived property types. In this first episode, we will look at the PropDefObject object since I recently worked with……

Continue reading

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

Continue reading