SAP Knowledge Base Article - Public

2598183 - Composite query table duplicating the measure names in the columns - WFA

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

  1. Create a Composite query in Report Designer
  2. Add at least two columns of queries
  3. 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".

query.jpgoption.jpg

Resolution

  1. Edit each RxCx segment
  2. Click Show Design View
  3. 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