Wednesday, November 13, 2013

Preparing for EPM Hyperion Upgrade from 11.1.1.3 to 11.1.2.3


We are preparing for upgrade from 11.1.1.3 to 11.1.2.3 on Windows server and back end will be SQL DB. 

Existing main components are Essbase,Planning,Reporting and Anaysis

Here are some links to gather information about architecture and to know defects fixed in the current release(11.1.1.3) to latest release to present to the team and management.


2> EPM System Defects Fixed Finder (Doc ID 1292603.1)





Thursday, November 7, 2013

LCM Utility is not generating Calculation Manager Rules and other options in Shared Services

Hi Readers,

Environment: 11.1.1.3 / websphere 6.x

My team was trying to schedule automate backups of web forms , calculation manager rules etc. And they are trying to generate migration file via LCM shared services and selecting the required components to generate migration xml file . This xml file will use to schedule the backup for the selected components via utility.bat.

In One environment they are able to complete the task but in other environments they don't see the calculation manager rules and other options in LCM.Please refer below screenshots for working and non working environment to understand more what we are going to fix

Working Environment:



Non Working Environment:













We raised SR with Oracle and it's more than 2 months we did not find the solution.
Finally, I start comparing the working and non-working environment and found that we need to set EDIT_DIM_ENABLED=true under planning Application and restart the services. This parameter fixed our issue.

Steps:
1> Open Planning application from workspace
2> Administration --> Manage Properties
3> Add or Edit the parameter EDIT_DIM_ENABLED  to true

Screenshot:




You can also perform this step from the back end. Here are the steps :


1> Modify the value manually of EDIT_DIM_ENABLED to 'true'  in the table using update SQL. 
Note: There may be many entries for this parameter . Please find the exact property_id  for your planning application and change this parameter in the same row
2> Stop RMI planning service
3> Stop Planning JVM
4> Start RMI Planning service
5> Start Planning JVM

Hope this helps .... Happy Reading.