Enable data audit trail for Essbase by adding AUDITTRAIL DATA as an application level configuration setting.

1. To turn on Data Audit Trail, add the following to the application configuration parameters: AUDITTRAIL DATA.
2. Perform ad hoc analysis through Smart View, make data changes through Smart View, and click on Submit - this results in an audit record being stored in the Essbase repository schema, in the table ESSBASE_DATA_AUDIT_TRAIL.
   When doing ad hoc analysis, there are many ways of getting a particular Point of View (POV) onto the grid. One of them is by using the POV toolbar, which allows you to zoom in on certain members in one or more dimensions. Refer to Selecting Members from the POV Toolbar in the Smart View documentation.
3. With Data Audit Trail enabled, you can view the audit trail in the connection Panel in Smart View. Under the connection information, click on the menu of operations under More to locate a menu option titled Audit Trail. Click on Audit Trail to view the data audit trail records for a cube.
   
   
4. The audit trail record shows the date and time of the change in the first column, the new value or the linked reporting object in the second column, and the POV in the third column. The time corresponds to your time zone. Click on an item in the audit trail for a description of the change.
5. You can display a sheet with the new POV and refreshed data value by clicking Ad hoc below the Audit Trail pane. When you click on subsequent audit records and click this icon, a different sheet is displayed with the POV for that audit record and refreshed data for that POV. This way, you can do further analysis on targeted data.

You can link a reporting object to a cell. When you do, this change displays in the data audit trail. You can add a note to a cell, attach a file, or reference a URL. When you make these changes, the cells are highlighted in your cube. See these topics in the Working with Oracle Smart View for Office on how to link reporting objects to cells:

You can easily export your logs to a new Excel sheet just by clicking an icon.

Export your log onto a new sheet using Export . Click this icon to export the logs with all the details for each entry onto a new sheet that looks like this:

Once exported, you can re-sort columns or remove them to show the information you want to analyze.

You can refresh the audit log to see your latest changes at any time.

When you make more changes to your data, you can refresh the log view any time. Click Refresh .

You can view audit trail data in the Essbase web interface. You can also export the data to an Excel sheet (in .csv format), purge the data before a specific date, or purge all of the audit trail data.

1. To view and manage audit trail data:

   In the Redwood Interface,

   1. On the Applications page, open the application, then open the cube.
   2. Select the Audit Data tab.

   In the Classic Web Interface,

   1. On the Applications page, expand the application.
   2. Click the Actions menu to the right of the cube name and select Inspect.
   3. Select the Audit Trail tab.
2. You can:
   • View audit trail data.
   • Export the data to a CSV file.
   • Purge the audit trail data until a specific date.
   • Purge all of the audit trail data.