1. Working with Oracle Smart View for Office
  2. Smart View and Oracle Analytics Cloud - Essbase
  3. Tracking User Activity with Audit Trail
  4. About Audit Trail

About Audit Trail

Data source type: Oracle Analytics Cloud - Essbase

An audit trail tracks user activity on an Oracle Analytics Cloud - Essbase cube.

In Oracle Smart View for Office, data entry or input can be tracked when connected to Oracle Analytics Cloud - Essbase. For example, when Audit Trail is activated, then updating and submitting data in all writable cells in an ad hoc grid would be tracked and displayed as a list items of in the audit trail.

Smart View logs audit trail activity in a pane within the Smart View Panel. After connecting to a cube, you access the Audit Trail pane by selecting Audit Trail from the Action Panel.

Figure 19-1 Audit Trail Selected from the Action Panel Context Menu


Smart View Panel for a private connection showing the Basic database selected. In the Action Panel, the "More" item was selected to reveal more menu item choices in a popup context menu. The Audit Trail menu item is highlighted.

The Audit Trail pane is displayed within the Smart View Panel. For example:

Figure 19-2 Example Audit Trail Pane

Audit Trail pane displayed in the bottom of the Smart View Panel. It shows a list of activity entries, with the column headings Date/Time, New Value, and POV. The first item in the list is selected. The bottom of the pane gives a narrative description of the selected activity, including the POV and the result of the action.

For each user activity tracked, the following information is stored:

  • User ID

  • Date/Time

  • Type of Operation

  • Comments/Linked Reporting Objects (LRO)

  • New Value

  • Old Value

  • POV Members

Only Date/Time, New Value, LRO, and POV are displayed in the Audit Trail pane. Selecting an log entry within Audit Trail provides additional information at the bottom of the pane. And you can export the details of the entry to view all available information for that entry.

You can also refresh the list of log entries in the Audit Trail pane, and launch a selected entry on a separate sheet to view the POV for that entry.