ODTUG EPM meetup in Pune

  

EPM Meetup - Pune

To all the Oracle Hyperion EPM folks based out of Pune, Planning for an EPM meetup in May 2016 (preferably on a Friday evening).Kindly share your views and comments.

Will share the date & venue. As this is first time happening for EPM community lets make it more of a informal session of gathering and getting to know each other.

I will stay tuned for the comments and suggestion.

Hoping this will be a great EPM meetup in Pune.

Data Relationship Management Integration with FDMEE-Part 1

In this blog let me cover the integration of the DRM with FDMEE (ohh boy i started to love this Patch, its getting very interesting) 

As per the product read me

Data Relationship Management Integration with FDMEE

In this release, Data Relationship Management has been integrated with FDMEE. Data Relationship Management functions as a hub where reporting structures are maintained, analyzed, and validated before moving throughout the enterprise. It is a change management solution for building and retaining consistency within master data assets.

Used in combination with FDMEE, you can:

• export dimensions and hierarchies from an ERP system to Data Relationship Management

• import data load mappings from Data Relationship Management

To integrate Data Relationship Management with FDMEE (optional):

Integrating On-Premises FDMEE with Oracle PBCS (Cloud)

Well gone are the days where we need to upload a file extracted from the Oracle EBS to the Oracle PBCS. Yes the Patch Set Update: FDMEE 11.1.2.4.200 allows you to integrate a On-Premise FDMEE with the Oracle PBCS and many more cloud applications. Cool huh...

Oracle Hyperion Financial Data Quality Management, Enterprise Edition can be used as a primary gateway to integrate on-premise and cloud based applications. This features allows EPM customers to adapt cloud deployments into their existing EPM portfolio. You might use the integration to import data from existing on-premise ERP applications, or synchronize data from on-premise EPM applications. For example, a Oracle Hyperion Financial Management customers can add Oracle Hyperion Planning data or a Planning customer can add more Planning applications. In addition, this integration includes writing back from a cloud to an on-premise application or other external reporting applications.

http://docs.oracle.com/cd/E57185_01/AGFDE/AGFDE.pdf

Why i have to apply "Patch Set Update: FDMEE 11.1.2.4.200"?

In this post let me cover the importance of the "Patch Set Update: Hyperion Financial Data Quality Management, Enterprise Edition 11.1.2.4.200"

 https://blogs.oracle.com/proactivesupportEPM/entry/psu_fdmee_11124200

This PSU is can be applied to the following releases:

·         11.1.2.4.000 and later

The Patch do have some notable new Features:

Deploying Hybrid EPM Applications

Opening big forms in Hyperion Planning

Came across this issue that Hyperion Planning a data form (it was one of the biggest form we had)  is taking a while to show the data and shows "fetching data" for a while.

This is was tested on 11.1.2.4

For On premise Hyperion Planning

Well there is flag available (for quite some time) to change the value of the number of the rows & columns are populated in the data forms.

As per the on premise document http://docs.oracle.com/cd/E57185_01/epm.1112/planning_admin.pdf

Setting Application Defaults (For all the users)
                                 

Customized role for End users to access the FDMEE (Data Management)

In one of our Hyperion Planning implementation, the user was asking for a role for a particular user to run the Interfaces and the batches.

We all know that “Run Integration” will do the trick (nothing special). After giving the “Run Integration” role to the needed user.

This is what the user was able to see/access, before you say it’s working as expected cool, there is a issue.

Calling calculation script from FDMEE

An interesting and quite useful functionality provided by FDMEE, Calling a calculation script once the data is loaded to a Planning/Essbase application (well the my co-worker Walid enlighten  me,thanks buddy)

The actual documentation of the functionality is here  Using Calculation Scripts

Under the Setup ->Register Target Application-> Calculation Script (3rd tab)

Invoking PushData.sh as ad-hoc or scheduled job from Hyperion Workspace

Background:

Users need to copy the data from the PSBP (Oracle Hyperion Public Sector Planning and Budgeting) manpower cube to the Opex cube (operating expense), since this is on 11.1.2.3.500 the Mapping Planning Applications to Reporting Applications is available already to do the job.

The Catch is there is no individual role available (atleast in 11.1.2.3 500) for running the utility. And giving admin access to run this utility was not a solution.

We need to have a job which can invoke the Pushdata utility and we can give access to a user to access only that job, similar to a FR report or a IR job (yes I am from the IR background J)

Issue:

The solution came to the mind is using publishing a batch file which will call the Pushdata.sh in Workspace so we can provision the job to the required user.

The Challenge was our Foundation & Planning were installed on Linux and the Reporting & Analysis was installed in Windows (this is a different story why it was done this way)

So need to have a perl script to login to the Linux machine from the windows and then need to call the PushData.sh

Solution:

We installed the strawberry perl as the perl which comes with EPM do lack some SSH packages needed for the remote login.

Batch file published to Workspace which calls the below script

EAS : "Failed to create client directory to write error file" during data load

A common error message when loading data via EAS console i encountered today,

 "Failed to create client directory to write error file" 

Solution:

Make sure the Path specified under Error file is correct, it might be a glitch that picks a invalid path. 

Edit the path to valid directory and reload the data file, you are good to go.

Upgrading ODI to 11g

The InstallTool.cmd , ConfigTool.cmd and the Opatch needs to be run as administrator especially in the  windows platforms

Background

Issue #1

We were in the middle of a installing EPM 11.1.2.4 for an implementation and the configuration failed. It throws the following error message

[EPMCFG] [TRACE] [EPMCFG-05020] [oracle.EPMCFG] [tid: 18] [ecid: 0000KsXRSDQ5mZ^5xVd9iW1LYPIx000002,0] [SRC_CLASS: com.hyperion.cis.ant.AntEngine] Error: {0}[[
D:\Oracle\Middleware\EPMSystem11R1\common\config\11.1.2.0\resources\preconfig\system\commonComponents.xml:547: Execute failed: java.io.IOException: Cannot run program "D:\Oracle\Middleware\EPMSystem11R1\common\VisualCRedistributable\10.0\vcredist_x86.exe" (in directory "D:\Oracle\Middleware\EPMSystem11R1\common\config\11.1.2.0\resources\preconfig\system"): CreateProcess error=740, The requested operation requires elevation

Why it’s important to run the 11.1.2.x on Windows platform with Admin access

The InstallTool.cmd , ConfigTool.cmd and the Opatch needs to be run as administrator especially in the  windows platforms

Background

Issue #1

We were in the middle of a installing EPM 11.1.2.4 for an implementation and the configuration failed. It throws the following error message

[EPMCFG] [TRACE] [EPMCFG-05020] [oracle.EPMCFG] [tid: 18] [ecid: 0000KsXRSDQ5mZ^5xVd9iW1LYPIx000002,0] [SRC_CLASS: com.hyperion.cis.ant.AntEngine] Error: {0}[[
D:\Oracle\Middleware\EPMSystem11R1\common\config\11.1.2.0\resources\preconfig\system\commonComponents.xml:547: Execute failed: java.io.IOException: Cannot run program "D:\Oracle\Middleware\EPMSystem11R1\common\VisualCRedistributable\10.0\vcredist_x86.exe" (in directory "D:\Oracle\Middleware\EPMSystem11R1\common\config\11.1.2.0\resources\preconfig\system"): CreateProcess error=740, The requested operation requires elevation