Enterprise Transformations, It's all About Performance Management

We have an option to use OnPrem FDMEE to connect with Cloud instance. If you planning to go that route there are some prerequisites which you need to perform on on-prem FDMEE instance to ensure its connectivity with cloud instance.  Prerequisite: ·          FDMEE should be patched: 11.1.2.4.200 ·         Configure SSL certificate in Web Logic Server (WLS) : o    Importing EPBCS SSL Certificate to WLS o    Update the hostname verification setting to configuring WLS to support wild cards in host name o    Enabling WLS with JSSE SSL, this is to support Java version of SSL o    Oracle documentation:  http://docs.oracle.com/cd/E57185_01/AGFDE/configure_ssl_certificate__102xf468157d.htm ·         Checking Cloud Connectivity: o    Retrieving application detail in FDMEE o    Oracl...

We have an option to use OnPrem FDMEE to connect with Cloud instance. If you planning to go that route there are some prerequisites which you need to perform on on-prem FDMEE instance to ensure its connectivity with cloud instance.  Prerequisite: ·          FDMEE should be patched: 11.1.2.4.200 ·         Configure SSL certificate in Web Logic Server (WLS) : o    Importing EPBCS SSL Certificate to WLS o    Update the hostname verification setting to configuring WLS to support wild cards in host name o    Enabling WLS with JSSE SSL, this is to support Java version of SSL o    Oracle documentation:  http://docs.oracle.com/cd/E57185_01/AGFDE/configure_ssl_certificate__102xf468157d.htm ·         Checking Cloud Connectivity: o    Retrieving application detail in FDMEE o    Oracl...

I ran in to this issue a couple of times, every time the reason was different and the solution was different. We get this error when we try to take LCM export of the application from Hyperion Shared Services. When shared services try to connect to Hyperion Planning, it internally calls the following servlet: http://<Server>:<Port>/HyperionPlanning/servlet/HspLCMServlet You may get this error when this call fails, it can be because of: 1. Time out the request, 2. Something is blocking this url, 3. Wrong server or port information in the EpmSystem Registry, 4. Because of an internal bug, 5. Something else! :) Here I will be talking about point 3. Situation: My OHS was configured to direct all the traffic using 19000 base port,  its the default port for OHS for EPM system. Because of some reasons I have to reconfigure OHS to 19001 and I have reverted it to 19000. Every thing else was working fine, I can access HSS, Planning Application, Essbase applicatio...

There can be a situation which will take you by surprise at first: When you can open a data from without issues from the Planning Web but when you try to open the same form from Smart view you will end up in Invalid form Error. The solution is not very complicated, you will be able to figure out the solution quite easily by looking at the error message. When smartview parses the xml to get: GetFormSlice as: <res_GetFormSlice><properties massAllocate="0" gridSpreader="0" cellsURLs="0"/><name id=<FrmId> displayName=<FrmName>/><grid> Here: FrmId is the Object_id of the from           FrmName is Object_Name associated with that id Lets look at the data form form Planning web: Its opening fine. When I open the same form, using the same user from Smart View: If you enable logs of smart view: [SVC] [NOTIFICATION:4] [SVC7257] [SVC] [ecid: 00iS34R^PbnFw0zxzP0AJz21HkE0j6YyS0002^g000000,0] Log...

Yes, who uses the report scripts now, but sometimes, that is the best option; here I am not going in the debate that which is better Report Scripts, Calc Exports or MDX. This post will only concentrate on what is the best you can do with the report scripts. I myself faced a challenge in which report script was taking a couple hours to export the data, we have to bring it down to the least, here are few observations which I would like to share with all and hope this will save our fellows' time. Following them I was able to cut down the time up to 1/100X: Here are few stages where we can optimize reports: 1. Pre Report Creation Optimization, 2. Formatting Optimization, 3. Member Selection and Grouping Optimization, 4. Report Specific Optimization, Before from the time report is extracted by report extractor and displayed by report viewer, we can do be some updates to the application, this is pre report creations optimization and this will be common for all the...

I have been the victim of this a couple of times, where everything was installed and configured properly without issues, however when you try to start OPMN it goes off with following error message: Starting opmn and all managed process... opmnctl startall: opmn failed to start. Error --> Process (index=X,uid=X,pid=XXXX)     failed to start a managed process after the maximum retry limit If you have something in logs, you can find the root cause and rectify the issue. But in some cases, the worst part of the issue is you wont find anything in the logs which will point you in right direction. If you look at Essbase logs, they will go in loop, they will keep on repeating the same information and there will be no error in the logs. One of the reasons: When ever you try to start OPMN it try to bind using loopback address so when loopback address is not mapped with hostname opmn fails to start. Here is a simple solution: You need to make sure there is an entry o...

There are times when we need to delete all the Alias, Descriptions, Formulas, UDAs, Smart Lists, or Attribute Binding etc. from an existing planning application. All these requirements are achievable, if you want to do it at once one of the options is: our good old Outline Load utility. In such scenarios "<NONE>" is your best companion! While loading members all we need to do is to add <NONE>  in the required column, this will remove all the existing associations and values. Let's take a scenario, as a last minute requirement your client needs cross tab reporting, your solution architect has decided to use Attributes instead of UDAs, as  repercussions you need to delete all the UDAs, change all the calcs etc. Now, in order to delete all UDAs you can: 1. Go to each member and delete UDA,  2. Go to relational database and do some unsupported background changes,  3. Use LCM, 4. Use the Outline Load utility, Here, we will be discu...