Consolidation and Translation Jobs Statistics

Financial Consolidation and Close allows you to enable consolidation rules logging to identify and troubleshoot issues related to consolidation and close performance. By enabling consolidation rules logging, you generate the consolidation performance diagnostics logs.

The Top 5 Consolidation and Translation Jobs by Duration table contains information available in consolidation performance diagnostics logs to help troubleshoot consolidation issues. Specifically, it reports on a maximum of five jobs that take the most processing time. For each of these jobs, this table identifies the rule template that takes up most processing time and the number of entities being processes by each rule.

The Duration column in this table indicates how long a calculation takes. However, because of multiple cores and parallelism, duration may not indicate the actual processing cost (in time taken), which is indicated by the CPU Time column. For example, if the Duration is 10 minutes, the CPU Time is only one minute if 10 cores are used for processing.

Always start by looking at the Duration column, which matches the visual data in logs and tables. However, to identify processing bottlenecks, check the CPU Time column, which is the true measure of a slow operation. Any row in this table with a high CPU time compared to other rows is a candidate for further optimization.