SAP Knowledge Base Article - Public

2417313 - Reverse join between a standard Foundation object (FO) and custom MDF object in Advanced Reporting

Symptom

  • Reverse join between a standard Foundation object (FO) and custom MDF object in Advanced Reporting
  • Unable to navigate from Standard FO object to custom MDF object in Advanced Reporting
  • Unable to move from custom MDF to standard FO object in Advanced Reporting
  • Reverse join between FO object to custom MDF object is not present in Advanced Reporting

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
    • Online Report Designer / Report - Canvas : Advanced reporting

Reproducing the Issue

As per current advanced reporting product code designed,

  • Forward and reverse join will be created if there is any association present between 2 standard FO objects.
  • Reverse join will not be created between standard FO objects and Custom MDF objects until there is an association present between them from source to target object.

In this scenario, there are associations present as below:

  • Sub Department 2 > Sub Department 1 

 

Sub Department 2.png

 

  • Sub Department 1 > Department

 

Sub Department 1.png

 

In Realms, we can navigate from Sub Department 2 > Sub Department 1 > Department

 

Advance Reporting - Correct Navigation.png

 

There is no association present between

  • Department > Sub Department 2

In Realms, we cannot navigate from Department > Sub Department 2 or Sub Department 1

 

new.png

 

Resolution

  • In order to create reverse join between standard FO and custom MDF object, an association has to be present between those 2 objects (association has to be created from source object to target object in order to appear reverse join between those objects in realms).
  • An association needs to be created between standard FO object - "Department" and Custom MDF object - "Sub Department 2" (Association has to be present from Department To Sub Department 2)

Additional Considerations:

  • The Parent to Child association will fetch data in Advanced Reporting only if the association has been established properly.
  • If this isn’t done properly, you might be able to see the association in Advanced Reporting, but only the Parent table will fetch data, not the child tables.
  • The best way to check if this association has been established, is by checking the data for the parent object, under Manage Data.

  • Child to Parent data association:

    • When you check Manage Data and select any item for ‘Sub Department 2’ , it will display its corresponding ‘Sub Department 1’
    • And when the same is checked for any ‘Sub Department 1’, it will display its corresponding ‘Department’
    • And with this, when you create a report in Advanced Reporting, starting from the last child node to the first parent node, you will be able to see data: (bottom to top)

      • Sub Department 2 > Sub Department 1 > Department

  • Parent to child data association:

    • When you got to Manage Data and select any item for ‘Department’, if the associations are established correct,  it should display associated ‘Sub Department 1’ child data.

    • And when the same is checked for any ‘Sub Department 1’, it should display associated ‘Sub Department 2’ child data.
    • And with this association, when you create a report in Advanced Reporting, starting from the first parent node to the last child node, you will be able to see data (top to bottom):

      • Department > Sub Department 1 > Sub Department 2

For more details on Object Associations: 2287729 - Object Association FAQ - Value Help - Employee Central

Keywords

Realms, Advanced, Reporting, Reverse, join, Relationship, between, FO, and, custom, MDF, Reverse, join, standard, FO, object , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem

Product

SAP SuccessFactors HXM Suite all versions