SAP Knowledge Base Article - Public

2502062 - Error in Pivot query - "Atleast One measure must exist for Pivot Query" while creating a Pivot Query"

Symptom

While creating a pivot query in Online Report Designer(Advance Reporting) user getting a prompt "At least One measure must exist for Pivot Query".

prompt.JPG

Environment

  • SuccessFactors
  • Pivot Query

Reproducing the Issue

Open Advanced Reporting / Detailed Reporting query and choose Pivot Query Designer.

If not selected already, the system will prompt for a measure:

prompt.JPG

The Measure is treated as the Raw data for a query which can be further sliced down with the help of rows and columns selected.

This is a prerequisite for a Pivot Query Designing.

Cause

Measure has not been selected.

Resolution

Select at least one measure for the Pivot Query.

Example: If you are creating a compensation report then compensation data can be selected as Measure.

Please drag and drop the column to mid of the designer section as shown below:

compensation measure.JPG

As soon as the Measure is selected, you will be able to proceed with Column and Rows selection to complete the query creation.

Additional note:For further steps on how to create Pivot Tables in ORD 2493771 - How to Create Pivot Tables in Online Report Designer (ORD)

Keywords

  • Pivot Query
  • Measure
  • Pivot Report
  • Must be selected
, KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HXM Suite all versions