I was recently asked whether it was possible to run the DRM batch client from a different server, than the one on which DRM is installed on. I had to think a bit on this as I normally just run any automations on the DRM box as a matter of habit. To refresh your memory,……
While working with the @CalcMgrExecuteMaxLScript Essbase CDF I came across some intricacies around using the RUNJAVA flavor of this CDF (RunJava com.hyperion.calcmgr.common.cdf.MaxLScriptFunction). I was developing some calc scripts in EAS with the intention of converting them to Calc Manager calculation rules for use with Hyperion Planning. I find the script editor in Calculation Manager to……
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……
Hello fellow Essbasers, I thought I’d pass on a little tip for an issue you may come across when creating an Essbase dimensional build. Occasionally you may need to build outline members that require quotes in one of the dimensional build fields (typically involving member formulas). Let’s take the following source data as an example.……
Hyperion planning users sometimes, when running a business rule that require some kind of selection through a runtime prompts window will complain that the OK and Cancel button are not displayed on their screen, as seen below. The runtime prompt window is too big for their screen resolution, so those buttons don’t show up and users……
Here’s a quick little post on some errata in the DRM documentation. I was recently looking at setting up a process to unload versions as part of my automation scripts. I was using regular batch utility execution, instead of the configuration file method (see here). According to the documentation, the way to do this is:……
For this post, I just wanted to document a quick tip when working on Windows Servers and using Remote Desktop Protocol (RDP) connections. On projects, I often end up using a service ID for logging in remotely to the Windows Servers that clients use. The issue with using a service ID is that other users……
Here’s a quick hack, which works on versions 11.1.2.4+. I haven’t had the opportunity to check out earlier versions. I ran into a scenario recently where I had a number of exports that I needed to rename. Now, DRM does not give us the ability to rename objects. It allows us to copy or move……
So here is a quick post for using DRM with Internet Explorer 8+. Now I never use IE when I am in development mode. It’s usually Firefox for me. But a lot of times, there are folks who have to use IE, because it’s the corporate standard (In 2016, it’s hard to see why, to……
It’s been a few months since my last post. In this post, I will detail the step (in Windows and Unix) to encrypt a password (using the PasswordEncryption utility) in order to use it with planning utilities, like for example the outline utility. This post will be the first one of a series that will end on with loading……
Q: What did the tree say to autumn? A: Leaf me alone. Now that I’ve got that out of my system, I thought we’d take a quick look at the humble DRM Leaf property. We’ve all used it one way or the other, whether we are setting up a hierarchy or applying formula logic. The Leaf……
The first time a user launches the ODI Studio they will be prompted or required to set up the initial connection to the Master and Work repositories. This connection information is stored in each user profile. So each user that wishes to log into the ODI Studio console will have to perform this action. To……
I need to preface today’s post with the following disclaimer, “I am not an HFM guy”. I understand it and respect it, but I am not an HFM developer. What I wanted to do today though, was look at how we can extract dimensions from HFM directly. A lot of times, we have to depend on……
Here is an easy one. So you were told you have to start using Smart View: instead of using the old Essbase Excel add-in or because your company chose to use Essbase, Planning, HFM… for all their EPM needs. Either way, you’ll have to download, install and configure Smart View. You can download Smartview directly from the Oracle……
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 thread pools or assigning threads.……
