2237987 - How to change the Cross Domain Left Outer Join behaviour for Reports via Provisioning switch

SAP Knowledge Base Article - Public

2237987 - How to change the Cross Domain Left Outer Join behaviour for Reports via Provisioning switch

Symptom

You run a report based on a cross domain which joins the Employee Profile with the Development Objective domain using a Left Outer Join and notice that the outcome is not as expected.

In fact, the report is fetching less records compared to Employee Profile single domain report.

Environment

  • SuccessFactors HCM Core
  • Ad Hoc reports
  • Detailed Reporting

Reproducing the Issue

  1. Login to the instance
  2. Select Reporting > Analytics > Ad Hoc Reports
  3. For this example, create an Ad Hoc report based on a Cross Domain which joins the Employee Profile with the Development Objective domain using a Left Outer Join for the fields Employee User Sys ID Equal to Development Objective Owner Userid.
  4. When you run the report you notice that less records are shown compared to Employee Profile single domain report.
  5. If youcreate a similar cross domain report with any of the following domains the report behaviour is different.(Performance Management, Compensation planning, Compensation Eligibility and Employee Profile)

 Note: same behaviour occurr with Live Data reports from the Online Designer.

Cause

The system behaviour is as designed.

Resolution

The report behaviour (Ad Hoc Report Builder or Online Report Designer), when the Left Outer Join is used, is dependent on the provisioning switch Disable database type left outer join for cross domain Adhoc reports.

This feature was introduced in order to choose the way the report behaves when Left Outer Join is used, is available via a Provisioning switch and disabled by default.

You can choose to enable or disable the feature based on the below considerations:

  • If the Disable database type left outer join for cross domain Adhoc reports is ticked > The Sub Domain Schema are internally applying where clause which makes cross domain reports to return less data.
  • If the Disable database type left outer join for cross domain Adhoc reports is not ticked > The Ad-hoc left outer join treat individual reports as a database table which makes cross domain reports to return more data.

The 'Disable database type left outer join for cross domain Adhoc reports' switch is opt-in and can be turned on as follows:

  1. Access the provisioning for your instance
  2. Search for Disable database type left outer join for cross domain Adhoc reports (from the Analytics and Dashboard Tabs & Misc Reporting section)
  3. Tick the switch
  4. Save

Keywords

  • Left Outer Join
  • Cross Domain
  • Ad Hoc reports
  • Detailed Reporting
, KBA , left outer join , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HCM Core all versions