SAP Knowledge Base Article - Public

2319401 - Right / Full Outer Join between tables in a Canvas report using Advanced Reporting Data source

Symptom

Is it possible to have Full Outer / Right Outer Join between tables in an Advanced Reporting query?

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

Environment

  • SAP SuccessFactors HXM Suite
  • Report Canvas Advanced reporting

Cause

Product Working as designed

Resolution

We currently do not have the option for Right outer or Full Outer joins in Advanced Reporting.

We only Inner and Left outer joins:

advReportingJoinType.png

Keywords

Advanced, Report, Reporting, REALMS, Canvas, ORD, join, types, Left, outer, full, inner, center , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM suite all versions