SAP Knowledge Base Article - Public

3133424 - Queries are getting mixed up when editing pivot table reports on advanced reporting


Queries are getting mixed up when editing pivot table reports on advanced reporting.

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


  • SAP SuccessFactors HXM Suite
  • Advanced reporting
  • Pivot table

Reproducing the Issue

  1. Create a pivot table query on advanced reporting (this is not happening to List reports). It can be any info, example below global job info:

    2021-12-14_17-14-24 (1).jpg
  2. Save the report and return on the return button up to report center
  3. Then, create a new report pivot query report on advanced reporting query as example below:

    2021-12-14_16-16-38 (1).jpg
  4. After that save it as well and return to the report center after adding some fields to the pivot table.
  5. Now, go to the “original report” and just open the query on the advanced reporting, but do not make any changes (do not need to).
  6. Just click on the Report Center on the top left side next to the Home / Report Center to go back to the report center:
  7. Now, open the query of the second report and the query will be overwritten by the first report.



This is currently a known issue by our engineering team. A fix is being worked by engineering team, but there is no time table yet. For internal reference WFA-30878.

Workaround available until the code fix is delivered: After doing the changes on the query it is required to click on the return buttom (to return from the query) and the cancel or done button (to return to the canvas page from the pivot table designer) are not clicked. The issue is only reproducible when it is only clicking on the report center button. So when going to a new report, the old session remains open and mixes up the sessions.


Save, query, report mixed, WFA-30878 , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem


SAP SuccessFactors HXM Suite all versions