2 Replies Latest reply on Apr 26, 2018 10:25 AM by 3512682

    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,

        • 1. Re: Identifying common columns and SAs for reports
          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).

          1 person found this helpful
          • 2. Re: Identifying common columns and SAs for reports
            3512682

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

             

            Thanks Gianni.