SAP Knowledge Base Article - Public

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

Symptom

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

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 HCM Suite
    • Online Report Designer / 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

If you feel the feature is important, we request you to submit an enhancement request for the same.
2090228 - How to submit enhancement requests for SAP SuccessFactors products
This will allow other customers to vote up and thereby express their interest on the same.
Our Product management teams review enhancement requests regularly and implement them if and when feasible.

Keywords

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

Product

SAP SuccessFactors HXM Suite all versions