2575909 - Slowness and performance in Reports - Online Report Designer

SAP Knowledge Base Article - Public

2575909 - Slowness and performance in Reports - Online Report Designer

Symptom

  • ORD reports are running slowly and taking more time to complete than before
  • A simple report with a couple calculated columns is taking around 20 minutes to finish
  • An Advanced Reporting report with around 70 columns and 15 tables are taking more than 20 minutes to complete

Environment

SuccessFactors Workforce Analytics (ANA) - All versions

Cause

  • The number of the fields (columns) returned by the query directly impacts the performance.
  • 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.
  • Complex RBP, with many roles and rules.
  • With Pivots, the inclusion in the query of columns that are not needed
  • Hide Duplicates option will often increase the time to run. With this option “off”, the results can be streamed from the database to the output as they are fetched from the database. However, with Hide Duplicates “on”, the entire database results must be brought into memory, sorted, and then de-duplicated. Report processing must wait until that query phase is completed.

Resolution

  • In case you need this report running faster you can follow the options below:
  1. Reduce the number of the fields
  2. Remove unnecessary different tables
  3. Apply filters
  4. Set a smaller target population
  5. Reduce the date range

Keywords

Slowness slow slowly performance report ORD Advanced Reporting Online Designer , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Product Enhancement

Product

SAP SuccessFactors Workforce Analytics all versions