SAP Knowledge Base Article - Public

3478019 - SF Reporting tool are not able to export the full data of organization information

Symptom

While we are using Canvas-Advanced Reporting or Story Report to export organization information, we are not able to using the existing query to export the full data.

Environment

  • SAP SuccessFactors HCM Suite
    • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
      • Stories in People Analytics

Reproducing the Issue

While we creating a Canvas-Advanced Reporing:

①Starting the query with Foundation Objects from low-level organizations to high-level organizations, the high-level organization which don't have low-level organization data's record will miss in Report.

②Starting the query with Foundation Objects from high-level organizations to low-level organizations,  the low-level organization which don't have high-level organization data's record will miss in Report.

③Starting the query with Jobinformation object, the position which don't have user assigned data record will miss in Report.

While we creating a Story Report:

It should be the same behaviour.

Cause

This is a limitation of Report query based on the object join.

Resolution

SF Reporting are not support to export the full data of organization information.

EC's Org Chart has no specific data field correspondence. When we try to reproduce it in the report tool, we will find that there is always data missing due to the influence of object query.

Keywords

organization information, report, query, limitation , KBA , LOD-SF-ANA-RCT , Report Centre , Product Enhancement

Product

SAP SuccessFactors HCM Core all versions