SAP Knowledge Base Article - Public

2647693 - Data from User (Background Info) or Talent Profile portlets is not populating in Advanced Reporting

Symptom

Columns from User (Background Info), e.g. Education portlet (e.g. Degree, Major, School), were added to an Advanced Reporting query but no data is populating.

Environment

  • SAP SuccessFactors HXM Suite
  • Advanced Reporting

Reproducing the Issue

  1. Go to Reporting 
  2. Create new Report Canvas and select the Advanced Reporting query
  3. Create a new query that includes information from any User (Background Info) object. e.g start from Global Job Information then Join to User (Background Info) > Education.

Result: No data or blank result.

Cause

The query has Current Date set for the User (Background Info), e.g. Education table.

Resolution

The query will need an Override for the selected User (Background Info), e.g. Education table.

  1. While editing the query go to Date Options > Overrides
  2. Select the affected table or portlet, e.g. 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.

Keywords

User Background info, Education portlet, Talent Profile, Employee Profile Data in Advanced Reporting , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HCM suite all versions