All Quick Tips related posts.
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……
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 to run the drill through……
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……
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……
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……
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,……
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……
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……
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……
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……
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.……
When I started working on Hyperion, most my projects were relatively small compared to the projects I have been doing the past 3 years. Now projects are over a year long with 2, 3, 4 phases and most of the times include Essbase, Planning, DRM, ODI to name a few of those tools. The bigger……
I wanted to go over a scenario that arises when you have enterprise licensing for ODI and how this relates to authentication. Specifically, when ODI is authenticated externally. Now, this is not something that most of us EPM developers are used to, but this is standard when BIAPPS is set up. Normally, we would just……
I often use Oracle Data Integrator (ODI) for automation and ETL processes in the EPM projects I help deliver. ODI is a wonderfully flexible and powerful tool that works incredibly well out of the box. But there are some little tweaks to ODI that I find necessary to resolve some occasional hiccups I encounter. I……
I’ve always wanted to put together a post about DRM’s audit capabilities. I feel this particular feature might be a bit underused. Nonetheless, it does offer up a number of possibilities. So, here is the first in a series that I will update periodically on this feature. Recently, I was asked whether it was possible……
