Thanks for your detailed explanation. I found your article informative as well. I have shared this information and it was agreed upon that retiring things that seem safe along with keeping backups of what was retired will be the solution. thanks again.

If anyone else has anything to add that would be appreciated. I know coming back to my boss saying that he will not have 100% certainty will not go over well. Is there an audit tool you all can suggest, or a method for searching for places which a report might be being called? thanks,

Yes, Sorry - I was speaking about 'Analysis' - although we do use BI PUB reports as well. Thank you for your answer.