Wednesday, 25 December 2013

MassGridStatistics Utility

  • A utility is available for Oracle Hyperion Planning that determines web form load times.
  • This utility, MassGridStatistics, opens all web forms within the Planning application.
  • After the forms are opened, an html page will appear showing the form options, suppression, number of row column and page members, and load times.
  • Any form having a load time longer than one second could potentially have scalability issues in a multi-user environment and should be considered for re-design.
  • Adding suppression (especially block suppression) and reducing the number of rows and columns are potential fixes that will reduce load times.
  • The MassGridStatistics utility is located in a .7z file called MassGridStatistics.7z.
  • Extract the file using 7-Zip. A readme file is provided listing the installation instructions and the steps to run the utility.
  • MassGridStatistics is included with the patch set and will also be in all future releases starting with
  • For earlier Planning releases, an SR will be necessary to have Support provide the utility. 

How to install and run the Utility?


  • This utility works best with Google Chrome. It is highly recommended to install Google Chrome to run this utility.
  • Make sure there are no users on the system.
Install Instructions:
  • Log off all users from Planning and stop the Web application server
  • Copy the JSP file from the MassGridStatistics directory to the Planning deployment folder. This location typically in environment would be:
  • C:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\Plannin0\tmp\servers\Planning0\tmp\_WL_user\Planning_11.1.2.0\xxxx\war
  • Copy the JSP file from the MassGridStatistics\WEB-INF\jsp directory to the WEB-INF\jsp location which is below the deployment folder.
  • C:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\Plannin0\tmp\servers\Planning0\tmp\_WL_user\Planning_11.1.2.0\xxxx\war\WEB-INF\jsp
  • Start Hyperion planning server.
To run the utility:
  • Login to Hyperion Planning using the Planning URL:
  • For example: http://<hostname:8300>/HyperionPlanning
  • After the login, the browser URL should redirect to the following:
      • http://<hostname>:8300/HyperionPlanning/LaunchPlanningCentral.jsp?Application=HPAPPL
  • From a different browser login to Planning, open a few forms that are used frequently. Make sure they load and there are no problems.
  • In the browser URL from step 2, replace the word "LaunchPlanningCentral.jsp" with "MassGridStatistics.jsp" and hit return or go. 
      •  http://<hostname>:8300/HyperionPlanning/MassGridStatistics.jsp?Application=HPAPPL
  • The browser should display a table with statistics for each form name as it loads.
  • Any form load that is taking longer than a second should be looked at as candidates for redesign since they will not scale in a multi user environment. 
  • Provide a list of forms that are most frequently used and number of expected concurrent users for these forms during heavy load times.

No comments:

Post a Comment