Enterprise Transformations, It's all About Performance Management

We had a up and running environment, it was compact deployment running on 9000 port, later we redeployed all the components to individual ports. Everything was working fine, we were able to access all the components however when were are trying to access planning applications from Calc Manager were are getting following error: http://<Server>:9000/HyperionPlanning/servlet/HspAppManagerServlet: Connection refused: connect Though we can access calc manager from workspace on 19000 port, we can see all three nodes under Calc Manager, but when we are expanding Planning node in calc manager we were getting above error in the Msg Box (as information), but after clicking ok, we can access all the rules listed under the planning applications. Error was obvious its still trying to connect to planning at 9000 but planning can be accessed at 19000 or 8300 port! How can we make calc manager to check planning at 8300/19000 port not 9000. Here are the parts of Calc Manager logs: ...

Here is one of the issues I have faced today, after applying few patches on one of our Hyperion Servers we were not able to run the EPM configurator, it was ending up in following error: We assumed that this may because of the patches we applied. Normally this error comes when you use a different user account for maintenance activities then the one which you have used during EPM installation. In that case we can modify the inventory file and change the user name in the file and re-run the configuration. The complete solution is well defined in the following Oracle's KM document: Enterprise Performance Management 11.x Configuration Utility Does Not Launch And Returns Error: "Inventory existence check failed for EpmSystem_username home was not found" [ID 1342764.1] For me, I was using the same OS user for all the activities, still was ending up in the same error and unfortunately EPM System Configurator was not even updating any logs at all. Every time we were runn...

When it comes to Planning Security we have to grant it at two levels: 1. Planning application roles  2. Planning artifacts access   Planning application roles are granted in Shared Services and Planning artifacts access such as Web forms and dimensions/members are maintained and defined from a Planning user interface. Security on these artifacts is defined from within the Planning application. Planning artifacts are stored in the Planning relational repository. So, if you planning to migrate security for an application which is in 11.1.1.x to 11.1.2.2, the best way is to use the typical upgrade approach but in case you cant use that, here is an approach in which we will be using the 11.1.1.3 LCM back to Restore it in 11.1.2.2. Here is an outline how we will be doing that, we will export security from version 11.1.1.3 using LCM, edit the files convert them in 11.1.2.2 supportable format and then will perform LCM import. In this blog post will only be t...

Here is one of the issues I have faced during Planning Application upgrade and how I was able to resolve that. I have restored Replica application which was from version 11.1.1.3 to an 11.1.2.2 environment, now when I tried to upgrade a Planning application from 11.1.1.3 to 11.1.2.2 I got  the following error in the logs(Location of upgrade logs: Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\planning): [FMWGEN][SQLServer JDBC Driver][SQLServer]The object 'DF__HSP_SYSTE__ESS_XXXX' is dependent on column 'ESS_DEF_PSWD' . On investigating further I was able to found that Planning is able to execute all the steps till line 70, line number 71 in the upgrade script is: ALTER TABLE HSP_SYSTEMCFG ALTER COLUMN ESS_DEF_PSWD VARCHAR(30) BTW you can find the upgrade scripts at: Oracle\Middleware\EPMSystem11R1\products\Planning\config\sql When I tried executing above ALTER query directly on database I got following: Msg 5074, Level 16, State 1, Lin...

Issue: Even though a user is provisioned for a Planning application in Shared Services, when you try to log into that application by that user you get following error: Failed to sync with user provisioning. Check Planning log for details The basic reason for this issue is the SID (Security token IDentifier) mismatch between Shared Services and Planning repository for a user. In other words  even though the User/Group name is same in both repositories but the identifier is different. Point to note: Planning uses SIDs, not the User or Group name for syncing and internal communication.  There may be times when you will be able to log into a planning application using few users and few of them will give this sync error. A simple way to check if you are running into SID mismatch issue is to check the SID in Shared Services schema table CSS_USERS/GROUPS and HSP_USERS/GROUPS.  Utilities which we use to sort this issue are ProvisionUsers and UpdateUsers bu...

Sometimes when you try to install EPM few products are not available for install, there can be many reasons for that. Couple of them are, you have not downloaded the proper assemblies or needed .rpm are not present in OS. This issue not only restricted for version 11.1.2.3. Here I have downloaded all the required assemblies but still when I ran the installer, all the products were grade out: My first guess was: I forgot to download any of the parts of installer or forgot to extract any of them. But on investigating further: Many OS packages were missing, so I started downloading them: And yeah you can use wildcards to search and download the packages and it will automatically take care of the dependencies:  Once packages were installed, I retried running installer few packages were still missing, installed them again: Once done, try installing again: For more information on RPM have a look at:  http://www.rpm.org/ Installation...

To enter notes, go to the KPIs/Measures: Click on the notes tab->Post New notes:  Enter the subject select category, enter contents and you can add attachments as well: Once you have selected the attachment click on upload: You will see it in Attachments section  After saving you will see it as above. To find them on the file system,  navigate to below location: Cheers... Rahul S.