As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
The Reporting Server's Impact Analysis tool is not aware of the content within the WebFOCUS content tree. The IMPACT ANALYSIS is available within App Studio for WebFOCUS objects that are stored in the WebFOCUS Repository or Content tree. For example: 1. Right-click on a Business Intelligence Portal content folder or the top level CONTENT and choose "Impact Analysis". This will open the application tree. 2. Select a Master File. 3. Click on "Analyze" to find any procedures that use this Master File within the Business Intelligence Portal.
Thank you for participating in the Focal Point Forum.
If you are happy to report against the WebFOCUS Repository then you can do something like this:
ENGINE SQLMSS SET DEFAULT_CONNECTION REPOSITORY
SQL SQLMSS PREPARE SQLLOOP FOR
from wf_content_revs t1
inner join wf_reposobj t2 on t1.obj_handle = t2.handle
where lower(cast(cast(t1.bcontent as varbinary(max)) as varchar(max))) like '%&TAB_NAME.EVAL%'
TABLE FILE SQLLOOP
prt_path AS 'Location'
BY objname AS 'Report Name'
ON TABLE SET EMPTYREPORT ON
ON TABLE SET BYDISPLAY ON
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
I have a number of variations on this, including one that lists all reports that by Synonym
WebFOCUS 8.2.03 (8.2.06 in testing)
Posts: 253 | Location: Melbourne, Australia | Registered: February 07, 2007