Enterprise Transformations, It's all About Performance Management

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 taking car

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 but sometimes these utilit

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 Pre-Requ

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.

To create employee, go to object view, click on Employee list and add:  Out of all the text boxes, First Name, Last Name and Email are mandatory. Once an employee is created you will be able to see it in left hand pane, if not the right click on refresh on employee list node:  In the same way in order to create measure click on measure list and add: Select the start date and frequency of the measure can be following:  Set the frequencies  Select Owner, collect, Target Setter etc  Select Range and your measure is created  Now let’s create a scorecard of Employee Rahul, using these measures:  To enter the results, login as owner/result collectors:  Right click on KPI and click on open you will see actual scorecard: Cheers...!!! Rahul S.