Symptom
Canvas Detailed reporting, Unable to find the Copy Column field under the Manage Filters.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP SuccessFactors HXM Suite
- Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD)
- Online Report Designer
- Analytics & Reporting(Ad Hoc, YouCalc, Canvas / ORD)
Reproducing the Issue
1.Create a Canvas type report from Report center, select Detailed Reporting to build the query, List Report.
2.Select columns under "Live Data", for example "Person and Employment Audit", then we can see these columns we selected under "Edit".
3.Tried to click on "+" and copy one column.
4.Unable to find the Copy Column field under the Manage Filters.
Cause
Currently this is an expected behavior for Canvas Detailed Reporting.
Resolution
We can use Calculated Column to export the same column then Filter on Calculated Column.
Create a Calculated Column in Detailed Reporting: https://help.sap.com/docs/SAP_SUCCESSFACTORS_PEOPLE_ANALYTICS/f5dbe211010c463bb0ca461cce851996/d83256bc4c6a48f3be007a69d021f5b6.html?locale=en-US
Copy columns currently not supported to select under Filter Designer, Manage Filters Page.
Keywords
Detailed, Reporting, Copy, Column, Manage Filters, Canvas Detailed Reporting, Copy Column field missing , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To