Identifying common columns and SAs for reports

3512682

Hi there,

Is there a quick way to analyse and identify the common columns and Subject Areas for few reports?

Thanks,

Gianni Ceresa

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).

3512682

What if one don't have access permissions to web catalog, What other alternative you recommend?

Thanks Gianni.