SAP Knowledge Base Article - Public

3242702 - How does story report fetch all countries Addresses from single Addresses table

Symptom

User is unable to view all regions Addresses from a single Addresses table.

How does story report fetch all countries Addresses from single Addresses table.

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
    • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
      • People Analytics (Analytics Cloud for SF)

Reproducing the Issue

  1. Login to instance.
  2. Navigate to reporting.
  3. Create Story report by choosing employment or person.
  4. Select Addresses table and check how data is displayed.
  5. Report will contain only few regions data (for example : Asia , Oceania region data will be present in report and data will be missing for few regions such as for Europe GBR , AGO , ARE).

Cause

Why data is missing for few regions : Navigation chosen to fetch data from table Addresses is not the correct path and also data fetched in report will be based on customer configuration.

Resolution

To fetch complete Addresses of all regions follow the below path:

Person-->Addresses-->click on related tables -->Person-->choose the tables as per report requirement (each table is equal to one region Addresses).

Keywords

Addresses, regions, story, data, few, country, display, table, object, result, person, related, path , KBA , LOD-SF-ANA-SAC , Stories in People Analytics , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , How To

Product

SAP SuccessFactors HXM Suite 2205

Attachments

Pasted image.png