1 person found this helpful
You mean for analysis? (so not Publisher reports based on subject areas)
You can generate a report in catalog manager and analyse that one, it will give you subject areas, tables and columns references by analysis, but it will not do the job the other way (telling you that one column is used in 5 analysis).
But with that information in 2 minutes in Excel you can get the info of the shared things, or if it isn't a one-shot thing you can load it in a DB and do the analysis there (Sample Application has scripts doing the report and loading in a DB and also has a model in the RPD and some analysis using that data).
What if one don't have access permissions to web catalog, What other alternative you recommend?