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 Advanced Reporting 
  • SAP SuccessFactors Report Center

Reproducing the Issue

Pivot Query Greyed Out - Realms.png


Step 1:

Home > Reporting > Report Center > New > Report Canvas > Select
Give a Report Name > Done

Report Canvas.png

Step 2:

Add Component > Tables > Add List Report Component

List Report Component.png

Step 3:

Edit the Query > Advanced Reporting > New

New Advance Reporting query.png

Step 3:

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

Creating Advance Reporting Query.png

Step 4:

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

Exporting the Query.png

Step 5:

Add Component > Tables > Add Published Data Coponent

Published Data Component.png

Step 6:

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


Step 7:

Click Cancel


Step 8:

Select an existing data source


Step 9:

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

Selecting Data Source - Pivot.png

Step 10:

Now you have option to create Pivot



Report Center, Pivot Query Designer, Advanced Reporting, Realms, Pivot, Pivot Query, Published data, Greyed, Grayed, out, missing, disabled , KBA , LOD-SF-ANA-ODS , Advanced Reporting , LOD-SF-ANA-ORD , Online Report Designer , How To


SAP SuccessFactors HCM Suite all versions