Symptom
A Learning Online Report Designer query displays different results for two users even though the report definition and their LMS domain permission is configured so that they will see the same output. The query uses LMS custom columns.
For User 1 - can view data for the custom columns and receives the expected result
For User 2 - no data for LMS custom columns and receives an output that is not filtered and beyond permissioned domain.
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 Learning
- SAP SuccessFactors HCM Suite
- Online Report Designer / Canvas Report
Reproducing the Issue
Analytics > Analytics ORD > Detailed Reporting > Live Data > Learning
For example:
- User created a query from Curriculum Item Status and added fields from User which are custom fields, e.g. Region, District, etc.
- the query has a filter on Region - The query is added to a report distributor bundle and sent to two recipients.
Result: Recipient/User 1 - receives correct report result
Recipient/User 2 - receives an unfiltered report and no data shows or the result is blank for the custom columns (but not for other fields).
Cause
The necessary workflow is not permissioned to the role of the user who cannot see the expected results.
Example: View User Custom Fields workflow is not added for the role.
Resolution
Troubleshooting:
- Check the fields included in the ORD query and from which tables or Learning schema these were sourced from.
- Check if the fields in question are custom fields. Go to Admin Center > Learning Administration > System Administration > Custom Fields
- Check user roles/workflow permissions in Learning Administration.
Ensure that View User Custom Fields, or the appropriate view custom fields workflow is assigned to the role.
Steps:
- Go to Admin Center > Learning Administration > System Administration > Security > Administrators
- Search for the specific admin. Note the Role assigned to the user's admin account.
- Go to System Administration > Security > Role Management > select the particular role
- Go to Permissions tab and check the permissions granted. Check specifically for view custom fields permissions. Note that there are several, for different tables/domains, i.e. User, Items etc.
- If the appropriate workflow is not added, modify the role configuration.
- To test, proxy in as the specific user and view the ORD query.
Online Report Designer query result after the permission change - columns now displays data
Keywords
LMS, ORD, Learning, Online, Report, Designer, Custom, Columns, domain, no data, for, specific, fields , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-LMS-ORD , Online Report Designer , How To