Columns from User (Background Info) > Education portlet (e.g. Degree, Major, School) were added to an Advanced Reporting query but no data is populating.
SAP SuccessFactors Reporting and Analytics
Reproducing the Issue
1. Go to Analytics > Advanced Reporting
2. Create a new query that includes Education information from User (Background Info). e.g start from Global Job Information then Join to User (Background Info) > Education.
Result: No data or blank result.
The query has Current Date set for the Education table.
The query will need an Override for the Education table.
1. While editing the query go to Date Options > Overrides
2. Select the Education table.
3. Choose "Show All"
4. Click on Set.
5. Save your changes.
The override will bring historical records for this table alone and no extra records from other tables.
Education portlet, Talen Profile, Advanced Reporting, Employee Profile Data in Advanced Reporting,WFA-16790 , KBA , LOD-SF-ANA-ODS , Advanced Reporting , Problem