Tuesday, July 20, 2021

EPM is Here!

Hyperion / Oracle EPM is out on Oracle eDelivery today (original date of this post: July 20, 2021... because The Internet Is Forever).

As with all EPM 11.2.x releases, it is very important to carefully crawl through the README before installing it.  Especially if you've never installed an EPM 11.2.x release before.  11.2.x is not your granddaddy's Hyperion!

If you're new to my blog, here are a few high-level points to be aware of:

Oracle has provided guidance within their latest EPM 11.2.x README's that, generally speaking, updates will be provided as new .dot releases rather than as PSUs for individual modules.  The exceptions to this rule are the Essbase Suite that's used under the covers and also Oracle DRM.

RCU is not your friend.  Search the "RCU" tag on my blog.  RCU is not optional in 11.2.x and you will suffer if you overlook this crucial step.

Likewise search my blog for the "OHS" tag.  You don't get a Windows service for Oracle HTTP Server ("OHS") in 11.2.

There are a few one-off PSEs coming out, but first check the quarterly Critical Patch Update announcements, such as the one that came out today.  There are some very severe vulnerability scores addressed in the July 2021 update:

July 2021 Oracle Critical Patch Update

Other one-off patches may come out at Oracle's discretion, so check Oracle's on-premises EPM blog every month to stay aware of what's new:

Oracle on-premises EPM blog

Back to the topic at hand....

I tend to go through 2-3 iterations when new 11.2 dot releases come out:

  1. Fresh install on a fresh Windows VM.
  2. Attempt an in-place upgrade on an older Windows VM.
  3. Fresh install on a fresh Red Hat Linux VM.
Each iteration is actually fascinating and reveals new details about the product as I work through issues I've never encountered before.... and I've been at this since Arbor Essbase 3.2 in the 1990s.

As always, I'll attempt to write a summary post of my findings after I get through at least test case #1 above.

Microsoft Patch Tuesday for July 2021 just finished in my new sandbox, so its time to shutdown and back it up to a new Gold image.  Be well and patch up!


  1. Hi Dave.. I have been reading your blogs regularly.. Thanks for that.
    I need 1 help if you can advise..

    We are in a process to install 11.2.6 EMP system.. currently using version. Our current user's are very frequently using Generic jobs in Workspace using URL in task list.
    Now in 11.2.6, Generic jobs are removed , so can you please suggest any alternative how user's can trigger batch scripts now? We also explored Windows Task scheduler but did not find helpful.

    1. Hello Vishal, thanks for your comment. An interesting question.

      If you have Calculation Manager and Essbase, one way you could do this is you could create a CalcManager script (it needs to be in script mode, not graphical mode). You create a little script like this:

      RUNJAVA com.hyperion.calcmgr.common.cdf.MaxLScriptFunction
      "SHELL D:\Scripts\YourScript.bat"

      In the above example, D:\Scripts\YourScript.bat (the name I picked was arbitrary... it can be anything on any drive) exists on your Essbase server. If if the script you truly want to run resides on a non-Essbase server, and if you're running a Windows environment, YourScript.bat would use the built-in WMIC (do a web search for the syntax) to invoke the script you want to run on the foreign server.

      wmic syntax example:
      wmic /node:FOREIGNHOSTNAME process call create "echo hello > d:\scripts\hello.log"

      Good luck!


  2. HI Dave.. Thanks for your response.. I tried multiple ways to run batch script in and outside Essbase server however not able to achieve this. Not sure if anything is missing in server to execute this from CalcMgr. My job is not getting triggered .

    1. Hi Vishal,

      There are multiple ways to get one EPM server to invoke a job that runs on another EPM server. Without providing free consulting on all the various options work specifically, I will give these tips:

      No matter which option you try, you will have a hard time if all of your services (I'm assuming you're running on Windows) are running as "Local System" rather than as a named AD service account. While this is my personal opinion, multiple back-to-back on-premises upgrade projects have proven me right each time.

      Powershell, built-in "wmic", and 3rd party "psexec" are just 3 options to look into outside of CalcMgr->Essbase RUNJAVA. Server-to-server integrations can get messy.

      Again, good luck :)


Thank you very much for your interest in this blog! I hope you're finding it helpful.

Please keep comments relevant to the topic in the post, as this blog is not a free-for-all substitute for Oracle Support or traditional consulting. If you have many questions unrelated to the specific topic at hand, consider contacting me on LinkedIn (https://www.linkedin.com/in/daveshay) so we may discuss the possibility of consulting.

Commenting on posts older than 90 days unfortunately goes into moderation, thanks to spammers who've been hitting this blog. Please have patience, and thanks for your understanding!

Comments including URLs linking back to gambling or other things unrelated to Oracle EPM will be deleted on sight. If you're an EPM consultant and are offering me constructive criticism or a tip, go ahead and DO link back to your blog or firm's website if you so desire.

Thanks again for reading!