SAP Knowledge Base Article - Public

2822515 - [1908] New Adhoc Report Execution Audit Sub-Domain Schema

Symptom

Addition of Report Execution Audit Sub-Domain Schema

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HCM Suite
    • Ad Hoc Reporting / Report - Table

Resolution

In the B1908 / Q3 2019 release, a new Report Execution Audit sub-domain schema is added to the Ad Hoc data source (Live Data).

sds.PNG

  • You can now generate a report that details reporting activities like Preview, Generate, Run, Schedule, Download, and Export.
  • The Report Execution Audit sub-domain schema currently supports Classic Reports, Ad Hoc (Report - Table in Report Center), and Dashboards 2.0 (Tile and Dashboard in Report Center).

Below are all the scenarios and the corresponding data

Note: There could be some expected blank records as highlighted below.

Also, when the Report Execution Audit is scheduled or executed offline, the latest record in the output (i.e. the Report Execution Audit itself) has the Report Name column blank and the Report Status terminated, even though the report runs successfully. This is expected for scheduled run via Run Offline and it is logged in the same way in the database, while the report is still being run and in progress it will not log any entry for Report name or status. Once it is completed successfully, we log this information and this will override the previous entry in the schema (i.e. in case you run the report again).

kba screenshot.PNG

For now, the domain does not support ORD/Canvas while reporting on it - however this feature is currently being developed by Engineering team.

Keywords

Report Execution Audit, 1908, Q32019, release feature, usage, analytics , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To

Product

SAP SuccessFactors HXM Suite all versions