SAP Knowledge Base Article - Public

2319401 - Is it possible to have Outer Join between tables in an Advanced Reporting query (REALMS)?

Symptom

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

Environment

  • New Advance Reporting UI
  • REALMS

Reproducing the Issue

In Legacy ODS,

We can choose from the below joins while joining two tables:
1. Inner Join
2. Left Join
3. Outer Join

Legacy ODS Join Type.png

While joining 2 tables in the new Advanced Reporting UI (REALMS), we have following join options:

1. Inner Join
2. Left join

Realms - Join Type.png

Outer Join is currently unavailable in REALMS.

Cause

Outer Join type is not available in Realms as per product design.

Resolution

Please feel free to create an enhancement request for the Outer Join option in REALMS.
The below Knowledge Base Article explains the steps for the same.
2281764

Keywords

  • REALMS
  • Advanced Reporting
  • Join 
  • Outer Join
, KBA , LOD-SF-ANA-ORD , Online Report Designer , Product Enhancement

Product

SAP SuccessFactors HCM Core all versions