1. User's Guide
  2. Smart View and Oracle Analytics Cloud - Essbase
  3. Tracking User Activity with Audit Trail
  4. Export Audit Trail Content to a Sheet

Export Audit Trail Content to a Sheet

You can export the items in an audit trail, including the detail for each entry, to an Excel sheet which you can save and analyze.

To export audit trail content to a worksheet:

  1. Launch the Audit Trail pane for a particular Oracle Analytics Cloud - Essbase cube, as described in Launching Audit Trail.
  2. At the bottom of the Audit Trail pane, click Export to Sheet, Export to Sheet button.

    All entries, along with the additional detail that is not displayed in the Audit Trail, are exported to a new worksheet. Details include:

    • User ID

    • Date/Time

    • Type of Operation

    • Transaction ID

    • Scenario

    • Comments/Linked Reporting Objects (LRO)

    • New Value

    • Old Value

    • POV Members

    The entries on the sheet can be sorted and filtered. Some columns may need to be widened in order to view the headings and entries.

    Following in an example of the content of an audit trail when it is first exported to a sheet:

    A worksheet containing the content of the audit trail for a selected Essbase cube.

    Some columns may need to be widened in order to view the headings and entries.

  3. You can save the worksheet, or just close it.