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 11.1.2.1.101 patch set and will also be in all future releases starting with 11.1.2.2.
• For earlier Planning releases, an SR will be necessary to have Support provide the utility. 

How to install and run the Utility?

 

  

Pre-requisites

• 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 11.1.2.1 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.

Results:

• 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.