BusinessObjects Board

View Free-Hand SQL Code

I have alot of Free Hand SQL reports and I want to know whether it is possible to query the CMC or Query Builder to search for some free-hand sql code. Reason being I want to identify which reports use a table in my free-hand sql.

If so, how?

hi
imho - report’s queries are stored in themselves, not in system db. in case the auditing is set to capture the sql queries then you can find them in audit db. Otherwise use some 3rd party tool or SDK for crawling in all reports.

2 Likes