HFM Data Audit – Oracle Table information
From Oracle HFM Admin guide, we find out that the Oracle table behind the HFM Data Audit process is called APPLICATION_DATA_AUDIT .
* The data audit log information is stored in the APPNAME_DATA_AUDIT table. You can back up or extract the information in the table. You should monitor the size of the log and clear it on a regular basis.
However, the table CONSO_DATA_AUDIT contains only 4 Customs dimensions as per previous release of HFM.
Extended Dimensionality for Financial Management:
* Starting with the 11.1.2.2 release, Financial Management supports more than four custom dimensions for a single application.
We are using Hyperion 11.1.2.4 and we are using 7 Customs Dimensions.