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 …

Remote XUL manager issue with oracle Hyperion Workspace with Firefox browser

Some users get a non-responsive blank screen as shown below while trying to open workspace in Firefox browser. The above “blank” screen is because of enhanced security settings in Firefox browser. To fix this follow the steps below. Search for “remote XUL” in the plugins page. Click on “Add to …

Oracle Data Relationship Management with external authentication

If you googled for the netjnibridge process error, you came to the right page. Scroll down to the section “Potential Pitfalls” to read about it. After installing Oracle Data Relationship management, some clients require that DRM is integrated with their active directory system like Microsoft AD, Oracle Internet Directory etc. …

Integrated workflow in Oracle Data Relationship Management

One of the main drawbacks of earlier versions of Oracle DRM was the fact that you need significant efforts to build work-flow into your metadata management. Oracle ships with DRM a basic work-flow development kit, using which the developers are expected to write Java code to build any meaningful work-flow. …