2 sessions at Kscope19

2/3 of the unlocked cube team was at Kscope19 with 2 awesome sessions… (at least we think so) Maybe next year the full team will be together! (we missed you Pete!) Anyway, during our sessions we were asked if we were going to share the videos we were showing since...

EPBCS, REST and Authentication

I’ve always been a big proponent of REST and REST-based integrations as it relates to the EPM stack, or indeed, to any cloud solution. Here is some sample content that illustrates this. When you use the (E)PBCS REST API (or any EPM API, for that matter), one issue that crops...

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

New Smart View version brings Drill through to Excel sheets from EPM Cloud

Up until last week, clients kept asking me if there was a way to get to the drill through reports without having to leave the excel world. Up until now, most of my clients leveraging Data Management wanting to run a drill through report needed to: find the desired cell...

Beginning in 11.1.2.4 Essbase, there is a new configuration setting that should not be forgotten – “WORKERTHREADS”. Why is this configuration setting important you may ask. Previously, Essbase operations that could run in parallel (calculations, data loads etc) used dynamically created threads for their work. Administrators need not bother setting……

This is quick tip for any admin that needs to update the Smart View version that is available to users for download from the Hyperion Workspace console. I was able to follow these steps so far since Hyperion version 11.1.2.2 and this is still accurate for 11.1.2.3.500. As always be careful,……

Thought I’d serve up a quick tip today on the DRM Configuration Console. Once in a while, you will come across an environment where you are unable to restart the DRM service even though you have administrator rights on the machine. I ran into this “access denied” error the other……

For this post, I thought I’d take a look at DRM imports. Now we are all familiar with text imports, so I thought I’d look at how DRM imports work against relational tables (a new-ish feature). This is something developers had been asking for a long time. Just like text……

Every wondered if there was a simple way to compare your current EPM version with a planned version upgrade. Some way to see all the cool new features that would come with the new version. Thankfully Oracle has a great online tool that provides a cumulative feature overview between EPM……

With the arrival of Dynamic Scripting in DRM 11.1.2.3, JavaScript is a valid scripting option within DRM. This is pretty neat because a script provides a more robust alternative to traditional DRM formulas. I also like the fact that you can now put comments inside your code. I thought it……

Now we’ve all been in situations where we’ve perform a lot of updates in an environment, let’s call it PROD and we need to perform a migration of only the objects (hierarchies, nodes, property values etc.) that changed, from that environment to, let’s say, DEV. In other words, we need……

Now that we’ve finished the DRM install, it’s time to create a new DRM application. This process is pretty straight-forward as well. As usual, let’s look at some of the pre-requisites. Pre-requisites Create a new repository (ensure you have the database rights to do this). Alternatively, you can choose to run……

Sometimes when connecting to Workspace, you will get a message saying the start up document couldn’t load, resulting in a blank Hyperion Workspace homepage. This is because most of the time users have not been granted access to the location where the homepage is stored or sometimes it’s because the homepage file is……

So, to kick things off, I thought I would start off with a simple post on how to install DRM 11.1.2.4. This will be part 1 of a 2 part series. To start off with, let’s make sure we have the prerequisites ready. Installation Prerequisites Windows 2008 R2 server IIS……

PREREQUISITES Download the ODI install file http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html. Make sure you have a Java JDK installed. I used the version seen below. The Oracle support matrix shows any version greater than 1.7.0_55 as supported. I’m not sure if 1.8 is supported though so I stuck with version 7. Note that support……

Until recently, I never encountered a situation where I needed a “yellow interface” in ODI (Oracle Data Integrator). Typical ODI interfaces leverage models that are manually created and point to static objects such as tables or files. On a recent project, I took to ODI to create an automation process……