Managing Historical Data Volumes with a Reporting System

Calculation processes in Oracle Hyperion Profitability and Cost Management require a high volume of data reads, writes, and clears during the processing of rules. The overall size of data in the calculation database can impact the speed of clearing data. Data clears occur during the initial stages of a calculation job when previously calculated values are being cleared as well as during the processing of rules as the system writes and clear temporary data storage used for processing individual rules. Profitability and Cost Management clears data of previously calculated values during the initial stages of a calculation job. During the processing of rules, the system writes and clears temporary data storage used for processing individual rules.

Minimizing the overall database size helps the calculation system maintain optimal calculation run times.

A common strategy to minimize data volumes in the calculation system is to create a Profitability and Cost Management reporting archive system to house the historical results required for reporting but not required for processing the current periodic results. Once calculations result validations are completed for current periodic data, the data can be migrated to the reporting system and the calculation system can be cleared in preparation for the next periodic cycle.