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 …

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 …

DRM 11.1.2.4 is here : DRG New Features

DRM 11.1.2.4 is here : DRG New Features Data Relationship Management 11.1.2.4 New Features: As promised Oracle has come up with more enhancements to the existing DRG ( Relationship Governance) workflows. In this blog post, I will be discussing more about the DRG Workflow Model and Task enhancements. Now we …

Creating an application in Oracle Data Relationship Manager (DRM)

Hi everyone, the following is a simple tutorial in creating a new application in Oracle DRM. This tutorial is meant for beginners trying to get their hands dirty with Oracle DRM, or even seasoned Hyperion professionals trying their hand at DRM for the first time. Please feel free to contact …

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 …