SAP Knowledge Base Article - Public

2645791 - Adhoc Report with Sub_Domain Job Information (Date Range) are Blank While Selecting Multiple Job Information Countries Specific Fields

Symptom

  •  Adhoc Report with Sub_Domain Job Information (Date Range) are Blank while selecting Multiple Countries
  • Select field from more than 2 Job Information countries Specific fields column while running Adhoc Report with Sub_Domain Job Information (Date Range) 

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental

Environment

Employee Central - Adhoc Report

Reproducing the Issue

  • Run a report: Adhoc report with sub domain: Job Information (Date Range)
  • Select field from more than 2 Job Information countries Specific fields column

Example:

  • Germany Job Information
  • Denmark Job Information
  • Spain Job Information
  • Finland Job Information

1range.png

  • Save and Run
  • Result : Blank Report

Cause

User selected fields from multiple Job Information countries Specific fields column

Resolution

  • It is expected behaviour.
  • User have to limit the country specific views to less than or equal to two otherwise huge query will be generated, which would cause performance issue.
  • Do Not select fields from multiple country specific views together.( should not be more than two )

Test:

  • Run a report: Adhoc report with sub domain: Job Information (Date Range)
  • Select field from No more than 2 (two) Job Information countries Specific fields column

Example:

  • Germany Job Information
  • Denmark Job Information

2range.png

Save and Run

Keywords

ECT-99160, Job Information (Date Range), Job Information countries Specific fields, Adhoc Report, ECT-102162 , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem

Product

SAP SuccessFactors HCM Core 1802