1 Reply Latest reply on Nov 19, 2012 4:08 AM by user248025

    Reg Sql Query

      Hi Experts,

      I have some N number of reports, i need to find a particular column from database that is being used by how many reports, i need help in finding a way to query that particular column.

      So kindly help how to implement sql query .. Urgent.

      Thanx in advance
        • 1. Re: Reg Sql Query

          Try to login Catalog manager and then create report and save this file as excel (this will give query info, relavent report for the column etc)

          1) Open catalog as online/offline mode
          http://IPadress:9704/analytics/saw.dll (its required for online mode only)

          2) once logged in then go to menu -->tools-->create report-->
          select "Select Type to report on" as "Analysis" with distinct and then move required column from left to right side then it will generate catalog report (if u get any error just ignore the details and press ok)

          3) save this o/p file to your local disk (.xls format)

          For more Refer Section 17.9 Creating Reports to Display Catalog Data Using Catalog Manager


          Edited by: Devarasu on Nov 19, 2012 12:03 PM