Symptom
This Knowledge Base Article addresses scenarios where end users may encounter unexpected data issues while running Story reports, such as:
-
Null values appearing for specific users
-
Missing data in certain columns
-
Filters displaying null entries
-
Users unable to view report data (blank data)
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 HCM Suite
Resolution
Take note of the widgets and columns that are not showing the data as expected for the users.
Then, login to the instance with a Report Admin user, go to Report Center and follow these steps:
- Edit the Story report (e.g. 'SF_COM_Gender_Pay_Gap_Analysis')
- Select the widget (e.g. Table, chart)
- Click on Designer > Builder
- Note the name of the Data Source (e.g. 'Compensation Information')
- Edit the Data Source
- Go to the Create Calculated Column menu
- Under Selected Column tab, find the column that is not showing data for the users e.g. Amount
- Check the Column ID and copy its content
- Paste the Column ID content in a notepad
- 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.
11. Also, pay attention to the join field. If join field permission is missing then no data shows up from object.
In this example if the Manager/Supervisor information table shows blank, besides Manage User > Data Access: User permission, please check Employee Data > Manager/Supervisor permission.
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 |
| Display Name | user_information_sac#USER#USERS_SYS_DISPLAYNAME | Employee Data > Display Name (View) |
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) and '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), permission may vary (e.g. Data Access). Additionally there are no Story-specific role-based permissions for Learning. For more details, refer to Permissions Required for Using Story Reports | SAP Help Portal.
See Also
- 3453290 - Users are able to see all data in Story report despite RBP limitations
- 3144704 - What are the various access levels to share a Story Report? - SAP for Me
- 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
- 2774845 - Questions regarding Learning permissions, roles, and restrictions
- 3339542 - Only Self data is seen in LMS Story report
Keywords
Null values, blank data, blank, null, data, values, fields, columns, appearing, Story reports, no data, column, field, empty, missing, information, filter, Users cannot see the data, RBP permission
, KBA , LOD-SF-ANA-SAC-RBP , Role Based Permissions & Authorizations , LOD-SF-ANA-SAC , Stories in People Analytics , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , How ToProduct
Attachments
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
| Pasted image.png |
SAP Knowledge Base Article - Public