EPM 11.1.2 - HFM Database housekeeping

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.


Comments:

Post a Comment:
Comments are closed for this entry.
About

A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
24
25
26
27
28
29
30
   
       
Today