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

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

Pivot Query Greyed Out - Realms.png

  • 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?

Environment

  • Advanced Reporting (Realms)
  • Pivot Query

Resolution

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

pivot.png

Step 7:

Click Cancel

cancel.png

Step 8:

Select an existing data source

data.png

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

Pivot.png

Keywords

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

Product

SAP SuccessFactors HCM Core all versions