Is there a way to recover an Excel report
Question ID: 104567
3
0

One of our users has accidently deleted one of their Excel reports.
Is there a way to recover the SQL Query and Post Processing scripts from a database backup?

Marked as spam
Posted by (Questions: 70, Answers: 111)
Asked on August 20, 2012 3:56 pm
79 views
Answers (1)
3
Private answer

You can get the data to recreate, If your DBA is able to restore a temporary sandbox copy of the database, you can look in the ANALYSIS_ITEMS table.
Make sure the DBA DOES NOT RESTORE over the PRODUCTION DATABASE.

SQL Server Example:

SELECT AI_NAME, AI_OWNER, AI_SUB_TYPE, AI_FILTER_DATA
FROM td.ANALYSIS_ITEMS
WHERE (AI_SUB_TYPE = 'ExcelReport') AND (AI_OWNER = 'alex_alm')

In the `AI_FILTER_DATA` column, you can see the SQL and the Post Processing options in XLM format.

The SQL is in the QueryBuilder section.

You won't need the Post Processing options unless the user had some elaborte vbs script.
If you need the post processing, the PostProcessBuilder> section.

It will take a bit of work to stip out the special characters `(#10)`, but that is pretty easy
with a simple search and replace.

See Example below...
![alt text][1]

[1]: /storage/temp/Excel_Reports_Recover_8-20-2012_3-35-46_PM_1.jpg

Marked as spam
Posted by (Questions: 0, Answers: 613)
Answered on August 20, 2012 4:48 pm
0
Thank you. Took a little work to strip out the special characters, but worked like a charm.
( at August 20, 2012 5:04 pm)
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top