SAP Knowledge Base Article - Public

3120568 - Reports with aggregated calculated columns are getting aborted (offline) or not running online

Symptom

Reports with aggregated calculated columns are getting aborted (offline) or not running online.

The same report is working for the same user in another instance.

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Execute the affected advanced report with aggregated calculated columns offline
  2. The job gets Aborted

OR

  1. Execute the affected advanced report with aggregated calculated columns online
  2. The reports takes a long time to be executed and then shows an error: Error rendering List Report component

Cause

System limitation.

Timeouts can happen when the report has aggregated calculated columns since every aggregated column causes a separate database query to be executed.

The execution of the report will depend on the RBP configuration, the data available in the company, company's configuration and the environment (Preview/Production). Because of it, sometimes the same report can work for the same user in one instance and doesn't work in another instance with the similar configuration.

Resolution

Use Pivot queries instead of aggregated calculated columns. As it only requires a single database query to run .

Help portal: https://help.sap.com/viewer/f5dbe211010c463bb0ca461cce851996/2111/en-US/f2c76efe94a240c5894ba7b67085a393.html?q=pivot%20query

OR

Break the report in multiple parts and apply filter and reduce the volume of data. 

Please note that creating reports, pivot queries and breaking the report in multiple parts is out of the support team scope, our work is focused on bugs and malfunctions, so the best option would be contacting your partner or the professional services if you need help to create the report:

2149831 - Contacting Professional Services, Partner and Account Management Team - SuccessFactors Cloud

Keywords

high memory consumption, aggregated calculated column, advanced reporting, report, Error rendering List Report component , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HXM Suite all versions