How to Recover Yellowfin BI 'Deleted' Reports
Sometimes reports may deletes accidentally, in general no
reports physically deleted from the metadata of database.
Check the status of report from “ReportHeader” table from
Yellowfin metadata database.
select ReportName,
ReportStatusCode from [dbo].[ReportHeader] where
ReportName =<<reportname>>
If report deleted then status would be “DELETED”.Following are the steps to recover the deleted report.
1) I have the report name “Report Dummy” & now
I’m going to delete it.
Prior to Delete
After Deletion:
2) To recover the deleted report, update the
ReportStatusCode=’OPEN’
3) Check the report in Report Folder.
the above steps didnt help for Private reports? Are there any other steps involved may be some additional queries to recover private reports?
ReplyDeleteThis worked great, thanks for documenting it!
ReplyDelete