Symptom
How can we get or extract a list of all Ad Hoc reports in the instance?
Environment
SAP SuccessFactors HCM Suite
Resolution
Currently there is no functionality that will directly export a list of all Ad Hoc reports in the system, but you can try the following:
1. Any user who has Report Admin permissions for Ad Hoc reporting will be able to view all Ad Hoc reports in the system. With this you can view a list of Ad Hoc reports in Report Center > All Reports tab by adding a filter for Report - Table.
For more information, please see:
Report Center Tools
https://help.sap.com/viewer/6ca0eee0540248b2b3ba91eaa1f18423/latest/en-US/8c70ab6a6314417b9c3580ccd750e50c.html
2. There is a new domain called Report Event Audit which can report on changes to Ad Hoc reports. You can use this domain to export a list of Ad Hoc reports by adding the Entity Name as a Column and selecting "Enable Distinct". The report will return a list of all Ad Hoc report names that exist in the instance. Please see this document over at the Help Portal for details about this release:
https://help.sap.com/viewer/7a5e1d53ab524d72bb5b98547e9f9c42/latest/en-US/7ca470d624ab4c68ae237e0a17d8808f.html
(Reference: AYT-23069)
2796410 - Report Events Audit - Sub domain schema for information regarding the reporting events
See Also
List of adhoc reports in the system created by the users
https://community.successfactors.com/t5/Reporting-Analytics-and/List-of-adhoc-reports-in-the-system-created-by-the-users/m-p/226699
Keywords
Ad, hoc, report, list, inventory, created, export, list , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-RCT , Report Centre , How To