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
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
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".
- Edit each RxCx segment
- Click Show Design View
- Click Edit on the right of the "Show measures on columns" and change it to Rows.
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