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 …

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 …

DRM EPMA Integration

If your organization is using Oracle Data Relationship manager for data governance and master data management, there is a good chance you are also using Oracle Hyperion suite for budgeting, reporting and consolidation applications. Some of the clients I worked for use Enterprise performance management architect to create and manage …

Oracle General Ledger Integration with Hyperion Data Relationship Management

Oracle DRM and Oracle Ebusiness Suite serve two different purposes in any organisation. While DRM acts as the metadata management tool, Ebusiness suite is used to run the core business of the organisation. Traditionally, metadata, i.e. segment values, hierarchies etc are shared between DRM and EBusiness suite using text or …