SAP Knowledge Base Article - Public

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

Symptom

  • 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

Environment

  • 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

Resolution

  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

    pivot.png

  10. Click Cancel

    cancel.png

  11. Select an existing data source

    data.png

  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

    Pivot.png

Keywords

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

Product

SAP SuccessFactors HCM Suite all versions