Oracle Data Relationship Sample Application

With the latest installment of Oracle Data Relationship manager released (version 11.2.1.0) many of you may be looking to trying it out. Luckily the installation process is fairly straightforward. This post, however, is not about installation, but creating a sample application.  Oracle have released a pretty full-on sample application called …

Configuring Oracle Data Integrator ODI 12C (Extension of EPM 11.2.0 Setup)

This post is a quick and simple introduction to configuring Oracle Data Integrator. I am only covering the configuration part because, in this instance, I did not have to install ODI separately. If you have installed Oracle Hyperion EPM 11.2.0, ODI will be installed automatically as part of the FDMEE …

Installing and configuring Oracle Hyperion 11.2.0

Oracle have released the latest version of Hyperion suite in December of 2019. Owing to various personal and professional commitments I didn't really have a chance to try it. I did get some downtime recently to install and try out the new release. I thought of sharing my experience with …

Oracle Hyperion Server not listening on port 19000

This has become a pesky issue for me when I was trying out the latest version of Hyperion suite (EPM 11.2.0) from Oracle. Having installed and worked on pretty much every version of Hyperion since the famed 9.3 release, I found it frustrating when the very last step in the …

Integrating Oracle DRM security with Hyperion Shared Services

Many companies have now started using Oracle Data Relationship Manager as their master data system. DRM comes with really sophisticated tools to maintain a single source of truth, and also provides efficient, effective and easy to use governance tools. Another good thing about DRM is its ability to integrate with …

HFM EPMHFM-66054: The System Was Unable To Find The Datasource Process For Application XXX

I have recently created a sample HFM application in EPM 11.1.2.4 environment. While there were no issues during the creation of the application itself, I ran into some serious issues when opening the application. The system threw the following error message, and wouldn’t open the application.   Hyperion Financial Management …

Externalizing security in Oracle Data Integrator

Hello everyone, I have been meaning to write this tutorial for a long time, but got stuck with work and other commitments. Well, better late than never I guess. Oracle has started allowing us to use third party authentication in its flagship integration product ODI since version 11g. This article …

Installing stand-alone Essbase client on Linux/Unix

A former colleague of mine reached out to me recently with an interesting request. He wanted to know how to install Essbase client on one of his Linux servers so that he can write batch scripts and call them using startMaxl.sh. I didn't quite understand why he needed my help. …

Hyperion error: GSM_unabletoacquireLSM unable to open explorer/reports

I've struggled with a particularly annoying bit of Hyperion errors on my brand new sandbox environment. It should have been a fairly straightforward install. I built a CentOS virtual machine, downloaded 11.1.2.4 version of Hyperion files and off with the install. The installation was very smooth, and so I proceeded …

Circumventing dynamic IP issues for small/home based businesses

If you are a small business or a home based business hosting your own email and web servers, it is important that your ISP assigns a static IP address to you. This will allow your DNS to point your domain to your servers using that IP address. unfortunately, some ISPs …