Audit trail for Financial Reports in Workspace
Organization Name
Markel
Description
Any Financial Report shows last modified date/time and user name, we were wondering if we can have an audit trial option to see all the edits made on the report or folder.
Also if the audit trail can show how many users and reports are being used on daily basis.
Use Case and Business Need
We can keep track of all the changes and follow change management process.
This is also helpful for SOX audit.
Original Idea Number: 73a7caef71
Comments
-
Oracle Analytics allows admins to track user activity and system usage to improve performance.
- OAC 5.3 Update: OAC & BI Publisher Audit and Report Usage: https://www.youtube.com/watch?v=sz1adkh-Y5o&t=63s
Oracle Analytics keeps track of all user transactions in an audit trail for optimal governance within one unified platform.
• Security Events Logging/Audit Trail: protection of the log files is based on OS file security; failed logon attempts are tracked in the log files and authentication and authorization events are captured in the log files as well.
• To protect the logs against tampering, the audit information is logged to a database and fully leverages database security.Oracle Analytics enables administrators to track usage at the user and system level across analytics assets so they can easily fine-tune performance for the analytics experience.
Some of the information tracked includes:
• Usage tracking logs all user data access including user identity, queries, timestamps, and the report/dashboard/analysis that were used.
• This information is available in a set of predefined dashboards that provide an audit trail of analytics usage. This tracking is also used by the platform's own performance optimization algorithms to recommend and create aggregate tables to improve performance.
• Metadata can be checked into a source code control system to track authorizations available for any specific date.- OAC 5.2 Update: Enabling Usage Tracking on OAC: https://www.youtube.com/watch?v=Sy9F7ozC3VI&t=220s
With Basic Usage Tracking users can see in real-time:
- # of logical queries in a project
- # of Physical Queries
- # of sessions
- Average Response Time
- # of Sessions
- # of logical queries by Start Date
- # of logical queries by Subject area name
- # of logical queries by Presentation name
Data Objects report canvas tab will show:
- top dashboard accessed by user
- top subject areas used by user
- Top data objects, dimensions, and metrics generated by user
you can also see the actual query used and the language of the query
0
