Category Archives: Level 1 Intermediate
Enterprise Data Management (EDM) REST API Requests I
Today, I thought we’d look at a new series which covers the Enterprise Data Management REST APIs. There is always a need to integrate with master data management tools like Enterprise Data Management (EDM), and so far, “EPM Automate” does not offer all the full-blown functionalities that REST does, in my perspective. I am sure……
Coding for Quarantine – EPM Cloud Upload File REST API Changes
I needed to do a follow-up to last week’s quarantine post. I thought today, we’d do a quick little post on how EPM Cloud REST functionality has changed, for the better, over the last few months. Last year, I did a KScope presentation with my friend, William Andreelli (who sometimes writes on this blog, and……
Coding for Quarantine – REST
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……
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……
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……
Oracle Integration Cloud Service for EPM III
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……
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……
Export Essbase Substitution variables to SQL
DRM Batch Client Execution from Other Servers?
DRM Pivots
So, after a bit of a break, it’s time to get back on the horse. Today, I thought we’d look at another DRM feature that has been around forever, but one, that I think gets lost during implementations. I am talking about the pivot feature, when using DRM exports. Recently, a requirement came up, where……
DRM Duplicate Check
One of the things I’ve always wanted to focus on, with this blog, is how the tools we use, sometimes provide simple and effective solutions. For instance, there are always cases, when we develop hierarchies on DRM, where we will need to filter down our exports based on the existence of duplicate attributes. In other……