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

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

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

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

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

Today’s post is a quick one where we discuss how to migrate applications from one Cloud environment to another. The latest version of Essbase on OAC, makes this process quite simple. I am not going to go through any of the scripted options on how to do this in this……

The September patch update for OAC brought a few cool little features which might be of interest to Essbase users. I thought today, we’d take a look at some of them. In this post, we will look mainly at changes from the Essbase console. I will devote a post to……

Last week, Test pods have been gifted with the latest PBCS update. Let’s see what September 2019 brings to PBCS. Welcomed new features: Data Management: Drilling down from Summary members. Before this update drill through via Data Management only supported drill through at level 0. Apparently now we can drill from summary……

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

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

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

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

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

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

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

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