nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to Find Deleted Reports and who deleted them?

Tugce Kucukoner-144150

Description

We need to find WHO deleted the BI reports.

Sometimes we can not explain how the reports disappeared. And we have to prove that who delete them.

And sometimes we can delete the reports by accident, we need to bring them back.

Use Case and Business Need

Sometimes we can not explain how the reports disappeared. And we have to prove that who delete them.

And sometimes we can delete the reports by accident, we need to bring them back.

More details

The current version of BI have not a future to monitor any audit log as we need.

Original Idea Number: c117c91405

Find more posts tagged with

Delivered

Reporting

Data Connectivity

Analysis and Data Visualization

Developers

Status: Delivered

Comments

Will Kelly

What method are you using to bring back deleted reports?

Tugce Kucukoner-144150

Hi Will, we didn't use any method until now. But just in case they recommend to use the archive and unarchive method which is unsustainable for us.

Brendan J. Doyle-Oracle

Hi there,

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

Tugce Kucukoner-144150

Hi Brendan Doyle,

Thank you very much for your answer, I did what you said it's totally what we need to.

Thank you again,

Best Regards

sreekanth chennabathini-149428

Yes - with out restriction access or by accident - if we lose any critical report and no resources to build it back - its better to have ability to track what went wrong or most important to bring it back on time.

Community DW Integration

When users are using a shared area to save there projects/catalog objects users with access might accidentally/intentionally might delete content. Having deletion tracker is the first place. Taking a step forward Dataops perspective we should be able to version things automatically atleast for the non prod instances and be able to integrate with version control system so that it will be easy on developers to be able to do this automatically and the ability to integrate into Migration cycles across the environments.

FPonte

Hi all.

Just my two cents on backup and recovery.

This may be useful.

Oracle Support Document 2460355.1 (OAC-C : Backup and Restore Recommendations for Customer Managed Oracle Analytics Cloud-Classic(OAC-Classic) Instances) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=2460355.1

Cheers

Fernando

Tugce Kucukoner-144150

Hi Fernando,

Thank you for sharing. I think its on OAC. We're using OTBI

Best Regards

FPonte

Got it.

I'm not sure how many people are editing your Catalog.

One of my current environments (OBIEE 12c) has more than 200 users and they can all create reports (in production) under their own folder but they are not allowed to save or delete on shared folders. Those are locked only for admins and some authors.

They develop reports in a QA environment (some consuming data from prod data) and once happy there is release process where one or more Key Analysts move the report to production environment (archive and import).

Again, that is on my current environment in OBIEE 12c so I'm not sure if that applies completely to OTBI.

All the best.

Fernando

Adrian Ward

The security auditing of our system will benefit from seeing any action in the catalog, including deletes, renames, moving, copying, etc