Enterprise Transformations, It's all About Performance Management

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. 

Workaround for LCM EPMA deploy errors: Error : Member 'D-T-D' in the Period dimension has no value for the Period  Type property.  Error : Member name 'D-T-D' in the Period dimension is only valid when Period  Type is set to 'DTS Time Period'.  Error : Member 'W-T-D' in the Period dimension has no value for the Period  Type property.  Error : Member name 'W-T-D' in the Period dimension is only valid when Period  Type is set to 'DTS Time Period'.  Error : Member 'M-T-D' in the Period dimension has no value for the Period  Type property.  Error : Member name 'M-T-D' in the Period dimension is only valid when Period  Type is set to 'DTS Time Period'.  Error : Member 'Q-T-D' in the Period dimension has no value for the Period  Type property.  Error : Member name 'Q-T-D' in the Period dimension is only valid when Period  Type is set t...

Implied sharing is an old thing everyone knows the reasons and solutions of that, still little theory about that: With Essbase implied sharing, some members are shared even if you do not explicitly set them as shared. These members are implied shared members. When an implied share relationship is created, each implied member assumes the other member’s value. Essbase assumes (or implies) a shared member relationship in these situations: 1. A parent has only one child 2. A parent has only one child that consolidates to the parent In a Planning form that contains members with an implied sharing relationship, when a value is added for the parent, the child assumes the same value after the form is saved. Likewise, if a value is added for the child, the parent usually assumes the same value after a form is saved.For example, when a calculation script or load rule populates an implied share member, the other implied share member assumes the value of the m...

Today I came across a question from one of our clients that: "what members are used on each data form WITHOUT having to go through the report generated out of our Planning app". We worked with client on this and reached to a simple query. All the form related information is stored in the following tables: HSP_FORM HSP_FORMOBJ_DEF HSP_FORMOBJ_DEF_MBR   HSP_FORM_ATTRIBUTES   HSP_FORM_CALCS   HSP_FORM_DV_CONDITION   HSP_FORM_DV_PM_RULE   HSP_FORM_DV_RULE   HSP_FORM_DV_USER_IN_PM_RULE   HSP_FORM_LAYOUT   HSP_FORM_MENUS   HSP_FORM_VARIABLES If we want to retrieve just the members included, we can concentrate on: HSP_OBJECT to get the Object_ID for form, Object_Type is 7 for forms. (Ex: Select * from HSP_OBJECT where OBJECT_TYPE = 7)   HSP_FORMOBJ_DEF Find the OBJDEF_ID for a particular form   HSP_FORMOBJ_DEF_MBR Use the above OBJDEF_ID to find the members:   Here the Mbr_ID is the Id of the member an...