1 Reply Latest reply: Nov 18, 2012 10:08 PM by user248025 RSS

    Reg Sql Query

    974884
      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
          user248025
          Hi,

          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)

          i.e,
          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
          http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/prescatadmin.htm#i1038437

          thanks
          Deva

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