In order to obtain a list of all of the reports that access a specific table with the use of Strategy, users can use Strategy Enterprise Manager to obtain this with the follow the next steps:
In Strategy Developer go to Project Configuration -> Statistics -> General for the desired project and make sure that Statistics is logging information about "Report Job SQL" as shown in the image below:
Note: This setting has to be check for every Strategy project logging statistics.
Using Strategy Enterprise Manager 9.x, create a new report with the following definition:
Attributes
Project (Page By)
Report (Row)
Report SQL Pass (Report Objects, not in the grid)
:
Filter
Type: Attribute Qualification
Attribute: Report Job SQL Pass
Qualify On: DESC
Operator: Contains
Value:
:
The report definition should look as follows:
Execute the report. This will retrieve all reports accessing the table specified within the Report Filter as shown in the image below:
