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 Column 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 Admin > Custom Columns
- Check user roles/workflow permissions in Learning Administration.

Ensure that View User Custom Columns, or the appropriate view custom column workflow is assigned to the role.

Steps:

  1. Go to Admin Center > Learning Administration > System Admin
  2. Search for the specific user.  Note the Role assigned to the user.
  3. Go to System Admin > Security > Roles Management > select the particular role
  4. Go to Workflows tab and check the permissions granted.  Check specifically for view custom column 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.

Result: In one case, granting the View Custom Column workflow did the trick.  The ORD query will not display data for the custom columns and will allow filtering on the custom column.

Learning Administration

workflow permission.jpg

 

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 HXM Suite all versions ; SAP SuccessFactors Learning all versions