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……
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……
Calc Manager Error:The dimension needs to be a text attribute dimension
After creating a new attribute dimension in PBCS/EPBCS, I tried leveraging it in a Business Rule right away but surprisingly the rule wouldn’t validate without throwing the following error “Error:The dimension needs to be a text attribute dimension” Supposedly, the new text attribute dimension isn’t being recognized as a text attribute dimension. It’s not a big issue……
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……
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……
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……
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……
Data load performance in PBCS/EPBCS
My last post was almost a year ago. I have been tied up on pretty large projects and never got a chance to find time to share some more insights on the daily issues we may encounter. I have been trying to stay away from the cloud as I felt it wasn’t quite there yet compared to……
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……
Running DRM Exports to FTP Sites
Today, let’s look at a type of external connection, which is seldom used, in my experience. We will be looking at running exports to an FTP site in this post. To illustrate, I’ve set up an FTP site on hostedftp.com (excellent cloud FTP provider). You could also be using your organization’s FTP server. In this……
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……
The ODI Agent, Restarts and Groovy
I tend to work with ODI quite a bit. Recently, I came across a scenario where the standalone agent on one of our boxes was turning itself off once in a while. While the issue was fixed, it did provide the impetus for this post. Today, we’ll take a look at the ODI (11g) standalone……
Data Exports and ODI
I thought today we’d take a look at whether it would be possible to do an entire post on record separators, and how they apply to ODI! Be still, my beating heart! Yes, this has all the potential of being one of the most exciting posts I’ve put up. So anyways, let’s get to it.……
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 Substitution Variables, The PBCS Edition I
These days, I find myself working with on-premises applications quite a bit. So, once in a while, it is refreshing to look at what Planning’s cloud counterpart can do. One of my absolute favorite features that Oracle has rolled out over the last few years is the advent of the REST APIs. I thought I’d……