SAP Knowledge Base Article - Public

2557157 - How to create pivot query based on Advanced Reporting (Realms) query when Report Center is enabled?


  • Pivot Query Designer window is grayed out in Advanced Reporting window
  • How do I create Pivot query based on Advanced Reporting (Realms) query from Report Center page?
  • How to create a Pivot Query based on Realms query?

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

Reproducing the Issue

After creating the query the pivot query desiner is greyed out.

Pivot Query Greyed Out - Realms.png


  1. Home > Reporting
  2. On Report Center > Select New > Report Canvas > Select
  3. Give a Report Name > Done

    Report Canvas.png

  4. Add Component > Tables > Add List Report Component

    List Report Component.png

  5. Edit the Query > Advanced Reporting > New

    New Advance Reporting query.png

  6. Build an Advanced Reporting (Realms) query > Save the Query > Return > Ok

    Creating Advance Reporting Query.png

  7. Edit Formatting > Export the Query > Give a name while Exporting the Query > Export

    Exporting the Query.png

  8. Add Component > Tables > Add Published Data Component

    Published Data Component.png

  9. Select the Published Data Component > Edit Query > Pivot Queries > New Query


  10. Click Cancel


  11. Select an existing data source


  12. Select Advanced Reporting > Select the Query which is exported in Step 4 > Ok

    Selecting Data Source - Pivot.png

  13. Now you have option to create Pivot



Report Center, Pivot Query Designer, Advanced Reporting, Realms, Published data, Greyed, out, missing, disabled , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-ANA-RCT , Report Centre , How To


SAP SuccessFactors HXM Suite all versions