SAP Knowledge Base Article - Public

2793129 - List of All Reports Created by Users - Ad Hoc / Report - Table

Symptom

How can we get or extract a list of all Ad Hoc reports in the instance?

Environment

SAP SuccessFactors Reporting and Analytics
Ad Hoc reporting

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. For b1902 instances (currently available in Production DCs), 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. For b1905 instances (currently available in Preview DCs), 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)


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, report-table list, inventory of reports, list of created reports, report - table export list , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA-RCT , Report Center , How To

Product

SAP SuccessFactors HCM Core 1902