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……
Have you ever created a list-type property in DRM and wished you could contextually filter the list? Do you have a DRG Workflow model that includes a property update that you wish you could restrict users from selecting an inappropriate entry? In this post, we’ll discover the use of external lookups that leverage the selected……
Welcome to Part 1 of a multi-part series detailing the creation of some out-of-the-ordinary processes leveraging Hyperion Planning command-line utilities, new (and old) Essbase CDFs and Hyperion Planning back-end repository tables. In this series, we will look at a requirement that arose at a recent client requiring the ability to update security within a Planning……
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……
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……
Thought I’d post a little tip that could prove useful to others that are looking to use the @CalcMgrExecuteEncryptMaxLFile and @CalcMgrExecuteMaxLScript Essbase functions (CDFs). I often find the ‘shell’ command that is available with MaxL scripting to be very useful. According to the Oracle technical documents the ‘shell’ or ‘Shell Escape’ allows the user to……
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.……
The other day I was running MaxL scripts on some Essbase applications at a client. In the corresponding MaxL logs generated by data load statements, I noticed the following warning being generated. I noticed that every data load and dim build was generating this same warning. WARNING – 1002023 – No message for message #1002023……
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……
A few weeks back I was looking to install Oracle Data Relationship Management (DRM) on a virtual machine for some testing. I fired up my trusty Windows 2008 server VM and went to work installing Oracle DRM using the installation instructions found on this very blog (written by the magnificent Vijay Kurian no less). The software……
You may find yourself needing to change the plan type that a Hyperion Planning webform references and wondering “How do I do that?”. Hyperion Planning will not allow a change to the plan type for an existing webform from the Planning web interface. The following steps will demonstrate how to do it leveraging the Hyperion Life……
The other day I threw together a marinade for some Pork Tenderloin (Premium Swift from Costco – great deal) with some miscellaneous items I had around the kitchen. It ended up turning out really tender and quite tasty. I’m not a big believer in measuring at least in instances like this. Cookies or something like……
Recently, Oracle released a fantastic new calculation command in the 11.1.2.3.500 patch set – the FIXPARALLEL calculation command (click here for details of this command). Expanding the horizon of ways that Essbase developers can perform multi-threaded calculations. I recently finished a project at client that had some stellar Exalytics machines chock full of CPUs and……
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……
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.……
