Most Cognos developers have been confronted with this situation before: A report runs perfectly fine in the Cognos Development or Test environment, but has some sort of issue in the Production Cognos environment. This scenario generally results in the Cognos team asking the question, "What are the differences in this report between the Cognos environment where it works (Development/QA) and the Cognos environment where it has an issue (Production)?".
IBM Cognos and Motio Best Practices Blog
Recovering deleted Cognos content usually means getting your DBAs involved to do a database restore. But more often than not, this means losing even more content, especially on heavily used development instances.