Identifying common columns and SAs for reports — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Identifying common columns and SAs for reports

Received Response
1
Views
2
Comments
3512682
3512682 Rank 3 - Community Apprentice

Hi there,

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

Thanks,

Answers

  • 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
    3512682 Rank 3 - Community Apprentice

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

    Thanks Gianni.