SAP Knowledge Base Article - Public

2497762 - No Data Returned for LMS Custom Columns in ORD/Report Canvas

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:

  1. 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
  2. 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:

  1. Go to Admin Center > Learning Administration > System Administration > Security > Administrators
  2. Search for the specific admin.  Note the Role assigned to the user's admin account.
  3. Go to System Administration > Security > Role Management > select the particular role
  4. 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.
  5. If the appropriate workflow is not added, modify the role configuration.
  6. 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

sample lms ord query.jpg

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

Product

SAP SuccessFactors HCM Suite all versions ; SAP SuccessFactors Learning all versions