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