Merin Joseph Posted March 30, 2023 Share Posted March 30, 2023 Does WebFocus have the functionality available that would allow us to identify the data elements included in all reports? Thank you, merin.joseph@kashtechllc.com Link to comment Share on other sites More sharing options...
Guest Posted March 30, 2023 Share Posted March 30, 2023 Hey MerinCan you give me an example of what you wish you could get from WebFOCUS? I'm not sure what you're looking for exactly. Thanks! Link to comment Share on other sites More sharing options...
Merin Joseph Posted March 30, 2023 Author Share Posted March 30, 2023 Hi Toby,Suppose if im looking for focus table or hold files , Is there any way to know which reports are actually using that ? Thank you.. Link to comment Share on other sites More sharing options...
Guest Posted March 30, 2023 Share Posted March 30, 2023 Well - we're in the territory of "Impact Analysis". It's easy enough to use the WFRS console to right click on a synonym and choose Analysis Reports / Impact Analysis, but on my system anyway, this is weak - it only scans the ibi/apps folders. Resource Analyzer on the other hand - that's got all kind of stuff in it. Pull up the Reporting Server Admin manual hunt for Running Impact Analysis Reports. See if any of that looks helpful. There's got to be a way to point back to the client (my reporting servers sit on another machine). If you could get it to search the repository also, that'd be helpful. Sorry I don't have more specifics. Other folks here use Impact Analysis to see what impact a Column change might have on existing reports. Maybe we'll get them to chime in. Link to comment Share on other sites More sharing options...
Merin Joseph Posted April 4, 2023 Author Share Posted April 4, 2023 Impact Analysis is weak in my end too. What is Resource Analyzer? Link to comment Share on other sites More sharing options...
Martin Yergeau Posted April 5, 2023 Share Posted April 5, 2023 I have the fallowing that I use to figure out where an element (table, column, fex, any string, ...) is used in the repositoryIn the sample code below, I am searching for GGSALES tableSELECT distinct T2.PRT_PATH AS 'Location', T2.OBJNAME AS 'Object Name', 'IBFS:' + T2.PRT_PATH + '/' + T2.OBJNAME AS 'Full IBFS path' --,T3.[WF_LNG] AS 'Lang' --,T3.[OBJDESC] AS 'Title' --,T1.OBJ_HANDLE --,CAST(CAST(T1.BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX)) 'Code' FROM <YourReposDB>.dbo.WF_CONTENT_REVS T1 INNER JOIN <YourReposDB>.dbo.WF_REPOSOBJ T2 ON T1.OBJ_HANDLE = T2.HANDLE /* To also have the title per language */ --INNER JOIN [WF82ReposProd].[dbo].[WF_NLSOBJ] T3 -- ON T1.OBJ_HANDLE = T3.OBJ_HANDLEWHERE UPPER(CAST(CAST(T1.BCONTENT AS VARBINARY(MAX)) AS VARCHAR(MAX))) LIKE '%GGSALES%'--and T2.OBJNAME like '%htm'--and T3.[WF_LNG] = 'en_US'ORDER BY 1, 2, 3 Link to comment Share on other sites More sharing options...
Debra Waybright Posted April 14, 2023 Share Posted April 14, 2023 If I remember correctly, you have to have this service turned on so it will capture usage data, but there are reports you can run from the Management Center. Are you running 8207 or newer? In the Management Center, Click on Resource Management, then open Reports, then open Resource Analyzer. There are a couple of usage analysis and Impact analysis reports. Usually, if I just want to know where a field or table is being used, I use SQL similar to what Martin posted. But that only gets what is in the Repository, so then I do a file search on the reporting server to see if anything on the EDASERVE is using it. Of course, that doesn't tell you if the report is actively being used. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now