Identifying Areas for Rule Optimization

Run the slow performing business rule from Calculation Manager to identify the steps that take the longest time.

Note:

For Consolidation and Close business process, you can run only On Demand rules from Oracle Hyperion Calculation Manager.

To identify steps that take the longest time:

1. Launch Calculation Manager.
   1. Sign in to the environment as a Service Administrator
   2. On the Home page, click Navigator , and then from Create and Manage, select Rules.
2. Locate and then double-click the rule to open it.
3. Click Launch to run the rule.
4. Input the required runtime parameters and click OK.
5. Click Log Messages to open the log file.
   
   

   Note:

   You may export the log messages to an XLS format file for easier evaluation and for submitting to Oracle Support, if needed.
6. Assess the log messages, paying special attention to how the total business rule execution time is spread across the number of calculation passes. Identify the following, which are candidates for optimization:
   • Passes that consume a bulk of the total rule execution time.

     Review the Pass # and Pass % columns to determine which pass is consuming most of the rule execution time. For example, in the preceding illustration, pass 3 takes the most time to complete (0.187 seconds) and occupies 96.392% of the pass time, indicating that it is a prime candidate for optimization. The start of a new pass is shown in bold.

   • Messages that indicate dynamic calc dependencies. Dynamic calc dependency messages identify member formulas that are dependent on another dynamically calculated member. Dynamic calc dependency, especially dependencies on sparse dynamically calculated members, can slow the overall calculation performance.

   Note:

   Use of CALCPARALLEL and FIXPARALLEL for concurrent processing in business rules by many users may result in slow performance. Because cache is allocated per calc thread, business rules that use CALCPARALLEL and FIXPARALLEL result in an exponential increase in resource consumption compared to serially processed rules.

   A single invocation of a business rule that uses CALCPARALLEL and FIXPARALLEL may perform acceptably. However, overall performance will deteriorate if multiple concurrent users execute such business rules (same or different). As more users concurrently run calculations with CALCPARALLEL and FIXPARALLEL, resource usage increases and may reach capacity, thereby decreasing the overall performance. Do not use CALCPARALLEL and FIXPARALLEL for business rules run by end users. Also, do not use CALCPARALLEL and FIXPARALLEL for business rules run in batch that are run concurrently with end user business rules.