How do we find the list of reports that being affected, if I delete a column from OBIEE RPD

Question

How do we find the list of reports which are being affected due to the deletion of a column in the presentation layer.

Can you please list out the possible methods to handle this situation.

Thanks, Helan

Terna · Answer

You can create catalog report with Catalog Manager (Tools-Create report) with analysis name and its columns. And then you can filter this report to find all analysis with your column.

The same for filters, prompts and other objects