Symptom
Error message occurred while Exporting and Import Adhoc Report from one instance to another instance
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 Employee Central - Adhoc Report
Reproducing the Issue
- log in Your Insatnce A
- Go to Adhoc Report
- Select Domain: Single / Non-Recurring Compensation (Date Range)
- Added the fields: User/Employee ID (Emp Info) / - Last Name First Name (Pers Info) /- HR Responsible (Job Info) /- Job Relationships /- Name Supervisor /- Legal Entity Legal Entity (Job Info Legal Entity)
- Export report and save in Desktop
- log in Your Insatnce B
- Go to Adhoc Report
- Upload Insatnce B Report file.
- Result: Error message
Example: An error : The Column Pill contains invalid columns.???ANALYTICS_LIST_VIEW_BUILDER_SUBDOMAIN_ectintBonusPayout_ectintBonusPayout#jobRelationsInfo#8363#hr manager#REL_USER_ID???,
Cause
- The Report definition to export from one instance to another instance as it is causing mismatch in logical column names which depends upon data model files along with picklist such as: Job Relationships, Home address, e-mail type
- Picklist option ID in source and Target instance are not the same
Resolution
Create new report selecting the required columns in target instance. Create new report from scratch in the target Instance and the required columns picklist Type: Job Relationships, Home address, e-mail type.
Keywords
ECT-103450, Export, import adhoc report, The Column Pill contains invalid columns, The Column Pill contains invalid columns.???ANALYTICS_LIST_VIEW_BUILDER_SUBDOMAIN, picklist Type, Job Relationships, Home address, e-mail type. , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem