Thursday, 16 April 2015

Serving Edited EAS Console JNLP File

There are 2 problems with EAS that, as far as I know, have been around since version
1. EAS Console will not be able to connect when using an SSL-offloaded, load-balanced EAS URL (such as

2. Periodically EAS will need to be restarted. The EAS Console will not be able to authenticate successfully  and the logs will be filled with “response already committed” errors.

The fix for both of these errors is to edit the “easconsole.JNLP” file. With the first we must add “:443” to the EAS Console URLs, to ensure that SSL communication will happen over port 443. For the second we have to add a line with ‘<update check="background"/>’ to the file.
In order to serve up this edited JNLP file with EAS, we must make a few changes to OHS. First we must add a directory called “easconsole” under the “E:\Oracle\Middleware\EPMSystem11R1\common\epmstatic\” folder, and place the edited JNLP file into it.

Then we must add the JNLP MIME type to OHS by editing the file “E:\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component\mime.types”. We must add in the following line:

application/x-java-jnlp-file jnlp

Then we must edit the file “E:\Oracle\Middleware\user_projects\epmsystem1\httpConfig\ohs\config\OHS\ohs_component\epm_rewrite_rules.conf” (change as appropriate for other versions of EPM).  We must add the following line:

RewriteRule ^/easconsole/easconsole.jnlp /epmstatic/easconsole/easconsole.jnlp [PT]

Restarting OHS will put this new configuration into place. Congratulations, your “Launch” button just became useful again!

Wednesday, 4 February 2015 Useful Resources

So I will dump all of the useful EPM links I have found so far into this consolidated post. If you find any more please let me know!


EPM General Information

EPM Documentation
EPM is certified with Internet Explorer 11
Life Cycle Management Changes in
easy error tackling - new Error Message Guides in EPM
Thoughts on deprecated Essbase features and the future of EAS

EPM Installation & Configuration

EPM Installation and configuration
EPM Test Drive Quattro
Taking for a spin in the cloud
Firing Up with John A. Booth’s Amazon Image
HFM Running On Commodity Linux

EPM Planning

Planning New Features


A brief glance at HFM from a techie perspective
Say Hello To HFM
Financial Management
HFM under the covers – the new architecture  
HFM and Copy App Utility - NOT! 


FDMEE has been released
FDMEE show must go on!  


DRM New Features Released! Official from Oracle!
DRM Patch Details

EPM Calc Manager

Calc Manager New Functions


For  all of the blogs above I highly suggest bookmarking them - they are certainly much more useful than this one!

Tuesday, 3 February 2015

Posts to Come

Just a quick note to say: I'm still here! I will create some posts in the next few weeks to discuss the following topics:

EPM -> upgrade
DRM installation
HFM - upgrade path, recommendations, etc

Sunday, 7 December 2014

Looking Up at the Clouds...

I wanted to take a departure from the purely technical posts I usually do to discuss something that should be in the thoughts of everyone involved in Hyperion right now: the cloud.

It isn't just a buzzword any more - cloud is very real. Oracle is clearly pushing Hyperion EPM and OBIEE into the cloud, we can see that with their cloud Planning service, and we will soon see Financial Reporting coming to the cloud as well. will see HFM become a Java application. Do not be surprised if some sort of "FMCS" cloud offering created further along the line.

The important thing to remember is that Oracle's cloud offerings are Linux-only, and to be able to offer a full Hyperion and OBIEE suite on their cloud all the components must be Linux compatible. In real terms this means everything becoming WebLogic applications or (if that isn't possible) standalone Java applications. This is where things are heading. Products that don't conform to this have 2 options, depending on if they are "strategic": become a Java application or get replaced by the strategic tool for that job.

To give two examples: HFM had to become a Java application: there is nothing to replace it and it is the only Hyperion option for performing consolidations (outside of creating custom Essbase apps and processes to support them - or silly things like that). EPMA Data Sync, on the other hand, can be replaced by the strategic tool for EPM-to-EPM loads which will be FDMEE. FDMEE is getting a whole bunch of new features in that will make it absolutely the best tool to be using for this - such as native EPM-to-EPM loads, HPCM support and native DRM-to-FDMEE mapping integration (there is a more complete list here). So really once they have taken out the EPMA dependency from HPCM we may see EPMA fall by the wayside completely.

But let's be frank here: Oracle is not yet in a position to give a really complete cloud option with all the flexibility of an on-premises solution. That will change over time, though, and the decision on whether to go to the cloud or not will probably not be with us techies, it will be with the people holding the purse strings. So how much will these cloud offerings cost?

You have to contact Oracle for that information :) But remember for PBCS it is a subscription fee, of around "$120 per user per month with a 10 user minimum" but each application is on its own environment (more info here). The FPRCS service that will be launched soon will also have a "per-user, per-month" subscription model. So for small shops with basic needs they are probably a nice solution. As for the full Oracle Cloud offering I unfortunately don't have any estimates for pricing, as that includes support costs as well, but I wouldn't be surprised if you have to contact them for a quote that would then be given on a case-by-case basis. So the big customers may not be so quick to whip out their credit card and buy themselves a few slices of the clouds just yet...

But for now how can we, those in the trenches of Hyperion Infrastructure, be ready for what Oracle may have in store? Well the best advice to give is to really try to stay up to date on which products Oracle are considering to be strategic, and to always try to align with that wherever possible. You don't have to jump for the clouds just yet, if you keep your feet on the ground - but keep looking up - you should be fine.

Monday, 20 October 2014

How to Fully Disable IPv6 in Windows Server 2008 R2

It has been ages since my last post, this time I am covering something which is not quite Hyperion-specific: IPv6.

First off IPv6 is the future. We need it. However in Oracle Hyperion EPM installations having IPv6 enabled can definitely cause some issues. So we do need to disable it completely. The steps to do this are not easy to get a hold of.

Run the following commands in a command-prompt:
netsh interface teredo set state disabled
netsh interface ipv6 6to4 set state state=disabled undoonstop=disabled
netsh interface ipv6 isatap set state state=disabled

reg add hklm\system\currentcontrolset\services\tcpip6\parameters /v DisabledComponents /t REG_DWORD /d 255 /f

ipconfig /all


If command prompt shows the above, in Device Manager, disable any ISATAP and 6to4 adapters.

ipconfig /all” should now show the below:

Now reboot:
shutdown /r /t 1