3213963 - How to find what permissions are missing for the users in the Story report - People Analytics

• Null values appearing for some users in Story reports
• Some columns don't display data for the users
• Filters are showing Null values
• Users cannot see the data in Story report

• SAP SuccessFactors HXM Suite
• SAP SuccessFactors People Analytics

Take note of the widgets and columns that are not showing the data as expected for the users. Log in the instance with a report admin user, go to Report Center and follow these steps:

1. Edit the Story report (e.g. 'SF_COM_Gender_Pay_Gap_Analysis')
2. Select the widget (e.g. Table, chart)
3. Click on Designer > Builder
4. Note the name of the Data Source (e.g. 'Compensation Information')
   
   
   
5. Edit the Data Source
6. Go to the Create Calculated Column menu
   
   
   
7. Under Selected Column tab, find the column that is not showing data for the users e.g. Amount
8. Check the Column ID and copy its content
   
   
   
9. Paste the Column ID content in a notepad
10. Review it to understand which object the field is coming from

In this example the Column ID of the 'Amount' field is ect_comp_schema#payComponentRecurring#PAYCOMPVALUE.

• The first ID (ect_comp_schema) indicates the category of the permission (i.e. Employee Central/Employee Profile)
• The second ID (payComponentRecurring) is the object where the field is configured (Pay Component)
• And the third ID is the actual field (PAYCOMPVALUE) 

Therefore, the permission for Amount in this case is available in RBP > Employee Data > Pay Components.

Some other common examples are:

Column	Column ID	RBP location
FTE	Employment#employmentInfo#J_FTE	Employee Central Effective Dated Entities
Business Unit	FoundationObjects#BusinessUnit#name	MDF Foundation Objects
Location	FoundationObjects#location#name	Manage Foundation Object Types
Person ID	person#personInfo#PERSON_ID	Employee Data > Biographical Information
User ID	user_information_sac#USER#USERS_SYS_ID	Manage User > Data Access: User
Original Start Date	Employment#employmentInfo#ORIGINAL_START_DATE	Employee Data > Employment Details MSS

Please note that not all fields are available in RBP separated from their objects. The field 'Person ID' above is one example. Hence, we recommend to always review the configuration of the object (e.g. 'personInfo' in Manage Business Configuration) to understand what permission is related to it (e.g. Biographical Information).

Also, for Employee Central data, users must have permission for the portlets as well (e.g. employmentInfo fields requires permission for 'Job Information Actions' (View Current and View History) or 'Employment Details MSS' and for personalInfo / personInfo it is also required the 'Personal Information Actions' (View Current and View History)).

For non-EC objects (e.g. user_information_sac), the permission can vary (e.g. Data Access). Please refer Permissions Required for Using Story Reports | SAP Help Portal.

Please refer the 'See Also' section for more KBAs about this topic.

3144704 - Role Based Permissions for Story Report [People Analytics] 

2974397 - Data Issues on People Analytics Report Story - Troubleshooting 

3072745 - Employment Details Portlet is not visible for the employees

3211866 - Data is not appearing in Advance/Story report even after assigning necessary roles to fields

Null values appearing, users in Story reports, People Analytics, no data, columns, field, empty, missing, information, filter, Users cannot see the data, RBP permission 

, KBA , LOD-SF-ANA-SAC , Stories in People Analytics , How To

SAP SuccessFactors HCM Suite all versions