Future-dated records are not displaying in Realms Advanced Reporting
e.g. new future-dated Department and Cost Center data was entered for a user's Global Job Information record. Upon running the report, the Department and Cost Center fields are blank.
SAP SuccessFactors Workforce Analytics
Record must have been Active in the system. Data will only be visible in reporting on the actual Effectivity date.
This is the expected behavior for future-dated records in Advanced Reporting as confirmed by engineering:
For example, if you use the fields directly from Global Job Information it will only fetch Current Data. So even for Show All, no future-dated Department and Cost Center will populate. In order to get future Department and Cost Center, you will have to join to the Department and Cost Center objects and then configure the Date Options to show future date / Show All.
The fields in Global Job Information always fetch Today's data for fields that have related objects (e.g. First Name / Last name are related to Personal Information), because from the perspective of the system future ones are not active yet. For this case, you can select the name fields from Personal Information Object. This is expected behavior and working as designed.
WST-7746, future-dated hires advanced reporting, reporting on future-dated employment information, Advanced Reporting future date , KBA , LOD-SF-ANA-ODS , Advanced Reporting , How To