Symptom
-
A composite query component is duplicating the columns even if the "Show measure name" is deselected
-
The columns are not getting merged in a composite query
Environment
SuccessFactors Workforce Analytics (ANA) - All versions
Reproducing the Issue
-
Create a Composite query in Report Designer
-
Add at least two columns of queries
-
See in the result that the data is getting duplicated in the columns
Cause
Having some measures on the columns and some on the rows caused the issue. The problem can be in the first or in the second column segments of the composite table - that is, the RxC1 or RxC2 segments. All of them might be set to "Show measures on the columns". Please change all of them to "Show measures on the rows".
Resolution
- Edit each RxCx segment
- Click Show Design View
- Click Edit on the right of the "Show measures on columns" and change it to Rows.
Keywords
Composite query table duplicating the measure names in the columns WFA component is the columns "Show measure name" are not getting merged merge repeating value record , KBA , LOD-SF-WFA , Workforce Analytics & Planning , How To
Product
SAP SuccessFactors Workforce Analytics all versions