X

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

How to Optimize Slow Business Rules Identified in an Application Activity Report

Tanya Heise
Sr Principal Technical Support Engineer

As a customer, how can I optimize slow business rules identified in an Application Activity Report?

Thank you to the following people for their presentation on this topic.

  • Jane Story, Sr. Principal Applications Specialist
  • Vinay Gupta, Consulting Member of Technical Staff

Steps for Optimizing Slow Business Rules

1. Use the Application Activity Report to help find out which business rules are taking the longest time to execute. Make note the business rule/calc script name in the reports.

2. Clone the application from prod service instance to test service instance

3. For each slow running business rule, execute the following steps:

  • Run the business rule from the Calculation Manager
    • Click Create and Manage->Rules from Navigator
    • Navigate to the business rule in the Calculation Manager System View, right click, and select open
    • When the rule opens, click Play
    • Provide RTP values, and click OK

 

  • Use Log Messages in Calculation Manager to identify which steps in the rule are taking the longest time.
    • After the business rule is executed, a new Log Messages tab appears with the following columns.

  • Using this information, you can see which pass (or passes) have taken the highest percentage of the total calculation time to run.

  • Optimize the identified steps and run the business rule again to ensure that it takes less time to execute but still calculates correct results and results in correct block creation.
    • The Log Messages tab helps the business rule implementer determine how the total business rule execution time is spread across the number of calculation passes.

    • The start of a new pass is shown in Log Messages with a bold line.

    • View the Pass # and Pass % columns to determine which passes consume most of the total business rule execution time.

    • The sections that take the largest percentage of the total time are the candidates for optimization.

    • After the changes are made, re-run the business rule and compare the log messages.

  • Once the business rules are optimized, migrate the changes back to prod service instance

 

Refer to the presentation for an example of troubleshooting a business rule before and after updates are made.

 

 

References:

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.