Proactive insights, news and tips from Oracle Hyperion EPM and BI Support. Learn Oracle from Oracle.

  • February 27, 2018

Automated Application Workload Performance Validation - A Customer Program from the EPM Development Team

Tanya Heise
Sr Principal Technical Support Engineer

Can customers automate their application performance validation?

Customers can automate their application workload performance validation using the EPM Automate Replay command. To facilitate the adoption of the automation process by customers, the Oracle development team offers a program to build the automation scripts for the first set of customers requesting it.

  • With this program, Oracle Development builds automation test scripts based on a customer’s application use cases and data.
  • The automation test scripts are given to the customer so they can run them each monthly cycle or as needed.
  • The objective of this program is to reduce the time it takes for customers to complete performance validation before moving to production.
  • It is a best practice for customers to test and optimize the performance of their application before going to production

Thank you to Vinay Gupta, Consulting Member of Technical Staff, for providing information on this topic.

Requirement Phase: (Customer)

  • Customer gives permission for Oracle to access their LCM snapshot for the purpose of creating automation test scripts.
  • Customer uses one of the following methods to provide Oracle Development with requirements:
    • Existing training material
    • Data in tabular format
  • Customer provides 3 to 5 use cases.
    • For each use case, the customer provides the following information:
      • The steps to perform (for example, open a particular form, set the POV/UDV, update the data, and submit the form)
      • Concurrency requirements (for example, how many users need to perform this use case at the same time with different POVs)
      • The expected UI response time (for example, within how much time the user should receive a response)
      • Parallel user/admin activities being performed at the same time (for example, file data loads, Smart Push, and Data Maps) and the number of users performing the activities


Development Phase (Oracle Development):

  • Oracle Development creates a test script. The test script is developed using the EPM Automate Replay command.
  • Each use case is executed for a given number of times with the given concurrency, and the average time is computed.
  • Measured performance is compared against the specified performance requirement.
  • If the performance requirement is not met, the number of concurrent executions is reduced by 1, and the use case is executed again.
  • This continues until either the performance requirement is met or the number of users is 1 (which means that the requirement cannot be met even with a single user).


  • Oracle reviews the results and provides the scripts, Performance Validation Report, and Activity Report to the customer.
    • It is customer’s responsibility to maintain the script and data files as their application design changes, and as they add more use cases.

  • Upon acceptance by the customer of the results, the script is also added to Oracle’s regression test suites.
    • Oracle does not provide the results on a continuous basis. They are used only for internal testing.


Do you want to participate in the program?

  • If you are interested in participating in this program, reach out to your Customer Success Manager (CSM) or devang.bhagat@oracle.com from the product development team with a request to participate.
  • After the request is approved, you will be asked to open a service request with the required information.




Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.