SAP Knowledge Base Article - Public

2362782 - Report is taking a long time to run

Symptom

  • Table (Ad Hoc) or Canvas (ORD) reports are taking a long time to load.
  • How to reduce the time taken for reports to complete?

Environment

SAP SuccessFactors HCM Suite

Cause

The Report execution time depends on multiple factors.
To list a few:

  • Number of columns and rows (amount of data)
  • Filters applied (if any)
  • Calculated columns
  • Aggregations
  • User’s target population (The amount of data the user has been granted access to)
  • Number of permission roles and group combinations that the user gets access to this target population (RBP complexity)
  • Server load:
    • In cloud applications, especially during business hours, the performance will vary.
      If we run the same report in quiet vs busy hours, the time to complete will not be the same.
    • Sometimes, even running the report in busy hours, it can run faster because on that specific point in time the server was not overloaded.

Resolution

The report execution time has been optimized as much as possible from our side, through multiple years of iterative improvements.

A few ways you could reduce the time taken for the report(s) to run:

  • Remove unused tables and fields
  • Narrow down the report's people scope
  • Reduce the date range, if the report is a date effective one
  • Schedule the report to be run offline, there by avoiding a wait time
  • Grant the desired target population through fewer and less complex RBP rules

See Also

2418819 - Reports Best Practices & Restrictions for Ad Hoc - ORD (Online and Offline capabilities)

Keywords

report, performance, time, why, taking, so, long, slow, enhance, improve, too, wait, fast , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem

Product

SAP SuccessFactors HXM Suite all versions