The number of records reduce when adding fields from different tables while reporting on the domain : Succession(Talent Pool v2 based nomination) in adhoc framework i.e. adhoc and detailed reporting - live data.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental
SAP SuccessFactors HXM Suite
- Report Canvas
- Adhoc Reporting (Report - table)
- ORD Detailed Reporting - Live Data
Reproducing the Issue
Create any adhoc/ detailed reporting - live data report of domain: Succession(Talent Pool v2 based nomination).
You will see that, when ever a field is added from a second table, the number of records reduce if the field value of the field from second table for that record is blank.
For example: You have added the field : 'Nominator Username' from the table 'Nomination Information' and you get four records. [Screen shot: Field_Table1]
Now, we add another field : 'Role Name' from table 'Role Information'. The records for whom the role information is blank got removed from the report. [Screen shot : Field_Table2].
In the domain: 'Succession(Talent Pool v2 based nomination)' the data in tables are bound by INNER JOIN i.e. those records will only reflect in the report which are present for both the fields of the different tables.
This is an expected behavior in adhoc framework.
A work around is possible in Adhoc report (cross domain).
In this report, you have to duplicate the same domain as many times as you select fields from different tables.
And in Relationships tab, you have to set the Join as LEFT OUTER JOIN.
record, reduce, Succession (Talent Pool v2 based nomination), adhoc, canvas, ord, detailed, reporting, live, data, row, join, inner, left, outer, cross, domain , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem