EPM 11.1.2 - HFM Database housekeeping
By Ahmed Awan on Aug 14, 2011
The following housekeeping practices are recommended when using Oracle / SQL Server databases with Financial Management:
· For HFM tables <appname>_DATA_AUDIT, <appname>_TASK_AUDIT and HFM_ERRORLOG, it is recommended to implement the following housekeeping best practices:
o Quarterly - Business to review the Audit logs, archive and delete.
o Half-Yearly - Archive System Messages and truncate table.
Tip: Put alerts in place so that action can be taken if these tables grow beyond the recommended number of records (> 500,000). Note large audit tables will have severe impact on HFM performance.