Enterprise Transformations, It's all About Performance Management

Few weeks back I got a call from a friend of mine, saying "Rahul, Planning date function are giving weird results, they are resulting in some numbers which are not even remotely related to a date". It can happen to anyone of us, if we are using date functions for the first time. Say if we have entered date like 20140101 (01-Jan-2014) and we need to add 15 days to this date to get a new date. A typical approach will be: "NewDate"  = @DATEROLL("OldDate", DP_DAY, 15); You will expect a result as 20140116 but you will be amazed to see the results.  "NewDate" =  21436101 ?? ... yeah ??? this is some kind of encryption and will give proper results for only legitimate calc script writers  I know today is 20130619, let use @today function and see if we are getting this date: "NewDate" = @TODAY(); Results which you will see:  1371600000 Now lets me tell you why part, Essbase Date function works on the basis of Gregorian Calender. He...

We got many string functions in new version of EPM but still for this post I will be taking String CDFs as an example. You can find String CDFs in Oracle's Sample Code. Please download them from below location: http://www.oracle.com/technetwork/indexes/samplecode/essbase-sample-522117.html Navigate to the following location, and if its 11.1.2.x you will get only one .jar there. Copy following files from extracted String folder to above location Now log into EAS Console, go to Maxl Script Editor, Navigate the register function script and Execute RegisterStringFunctions.msh to register the functions. For me it didn’t run for the first time so I have copied CDF_String.jar  to below location as well: It will prompt for setting few user variables please set the value for them. To check if the functions are registered successfully : In EAS Console Right click on the servername->Edit->Functions and you will get the following: Now j...

When we export the BRs, EAS exports the BRs in a xml file, this xml files contains all the BRS, Security (if you are not exporting for Calc Manager), locations etc. Now if we are trying to migrate the BRs from say Production to Development environment, we have to update the location of the BRs the .xml file because when we export our .xml will have the BR location of Production and here we are trying to migrate the rules to Development, so we need to update the .xml and modify the location of Brs. Here are the steps to export and import rules from one server to another: 1. Log into EAS console of Source Environment using an admin id,   2. Right Click on Business Rules Node,   3. Click on Export,   4. In the right hand pane you will get all the BRs listed, Click on Select All, 5. Uncheck For Calc Manager, 6. Click on Dependents, 7. Export the rules, 8. This will ask to save the BRs in a XML format save the .xml file, 9. Save As the .xml file with a diff...

To perform LCM we all know that we go to shared services so the first http request which comes into picture is: /interop/index.jsp It is the first .jsp page which we access when we try logging in our Shared Services, When you try to log on, it a POST request (POST submits data to be processed  to the identified resource. The data is included in the body of the request. So essentially GET is used to retrieve remote data, and POST is used to insert/update remote data.) : /interop/logon Once you are in you can see: Application Management and under which there are User Directories, Application Groups and File System, these are populated when we have GET request:   /interop/casresources/resources_en.js   and POST:  /interop/framework/cas/initAction Now when we expand the Application Groups: /interop/framework/cas/expandProjects   /interop/framework/cas/listProjects When we expand Planning Group: /interop/framework/cas/getApplic...

registry-cleanup: It can be used to cleanup the bad entries in the Shared Services Registry.   There is no harm of running this utility as a regular cleanup process . This utility runs on the basis of some rules which are passed to the utility using a xml, but default it uses the default-rules.xml file present at following location: MIDDLEWARE_HOME\EPMSystem11R1\common\config\11.1.2.0\resources\registry\cleanup There are six default rules in the default-rules.xml file, these are:   1. Remove components without parent HOST node,   2. Remove APP_SERVER components with just HOST components in parents, 3. Remove components without any children or parent nodes, 4. Remove HOST to HOST links, 5. Remove webapps with invalid ‘serverName’ property, 6. Merge duplicate webapps. If you look at the xml and investigate the first rule:  <rule description="Remove components without parent HOST node">         <delete>...

When you will start using Hyperion on Firefox, you may get a blank screen when you try to log into workspace or you may not get the Hyperion Menus like File, Edit, View, Administration etc. Sometimes its also been observed that your save Planning data form button, refresh button etc are disabled. In order to get rid of these issues we need to allow our hyperion urls to load XUL contents, to do so we need to Install and configure the Remote XUL Manager add-on, and then restart Firefox. Its is pre requisite for Firefox to work with Hyperion, we can install the add-on from   https://addons.mozilla.org/en-us/firefox/addon/remote-xul-manager Once its installed: 1. Click on the Firefox button on the top left, then select Web Developer, and finally Remote XUL Manager to open the management window. On Mac OS and some other systems, the menu item is accessible from Tools > Web Developer > Remote XUL Manager. 2. To add a domain, click on the Add button and then enter...

When we try to log into workspace, workspace ensures that all integrated applications are started. That is an additional overhead which makes the logon slow. To get rid of this check (For those applications which are not started) we can disable integrated applications that are not started, on the Workspace Server Settings panel.  To access Workspace Server Settings: 1. Select Navigate,  2. Administer,  3. Workspace Server Settings, 4. Click Enabled Products,  5. Deselect any products that are not started. You can use below link to check the list of products intergrated to workspace: http://<ServerName>:19000/workspace/status You will get a xml like that: Cheers..!!! Rahul S.