Is there a way to look up what reports are using a metric?

[mkegruber]

Team,

I have a metric - but I want to know which reports are using it as a data source.

Is there a way to search this?

[Shraddha Kadam]

Hello @mkegruber ,

Please use this below steps -

1. Navigate to Reports > Administration > Report Sources.
2. Find and open the specific Data Source record that you're interested in.
3. Once on the Data Source record, look for a Related Links section. You should see a link titled "Reports using this report source" (or similar). Click on this link.
4. This will display a list of all reports in your instance that are configured to use that particular Data Source.

[kalpanashar]

• Check the metric_instance Table Reports that use metrics typically pull data from the metric_instance table. You can search for reports where this table is the data source and then filter by your specific metric definition.

• Use Report Builder Filters Go to Reports > View / Run, and filter reports by data source. Look for reports using metric_instance or related tables, and check if your metric is referenced in the filter conditions or groupings.

• Scripted Search (Advanced) If you have access to scripting, you can query the sys_report table and inspect the data_source or table fields to find matches. You may also need to parse the report conditions to locate your metric.

[Ankur Bawiskar]

@mkegruber 

you can search in sys_report.LIST with Table = your metric table

If my response helped please mark it correct and close the thread so that it benefits future readers.