To configure the Builder to display the table as shown in the screenshot:

Column: Location (B):

Location is displayed as a column header in the table, grouping the rows by location.

Table Structure: Aggregated List (C):

The table structure must be set to an aggregated list to summarize the count by location.

Column: Count (D):

The Count column displays the number of occurrences or employees for each location.

Validation Using the Check Tool:

TheCheck Toolin SuccessFactors HXM Suite includes a predefined check for validating whether a user exists and is correctly configured for People Analytics (e.g., Story Reporting in SAP Analytics Cloud).

Running the "Availability of user record for People Analytics" check ensures the user record is properly synced.

Steps:

Go to Admin Center → Check Tool.

Search for and run the"Availability of user record for People Analytics"check.

Join Types in Queries:

Inner Join:Only returns rows where there is a match in both tables.

Left Outer Join:Returns all rows from the left table and matching rows from the right table, filling in NULLs where there is no match.

Scenario:

Adding the Proxy Information table creates a situation where some records from the Basic User Information table no longer match with Proxy Information.

Changing the join type toLeft Outer Joinensures that all records from the Basic User Information table are included, regardless of matching Proxy Information.

Steps to Adjust Join Type:

Edit the query.

Locate the join between Basic User Information and Proxy Information tables.

Change the join type fromInner JointoLeft Outer Join.