- SAP Managed Tags
"I previously came across an issue where the client requested the Cost Center field to be included in the user profile within LMS. They want both the Cost Center ID and Cost Center description to appear in a single field." I am writing this blog to assist scenarios where clients require multiple data elements to be displayed within a single field. For example: If the client has the requirement to concatenate other fields like First name and Last name etc. so this approach will be useful in all the cases.
Issue Overview
The client has requested the inclusion of the Cost Center field in the user profile within the SAP SuccessFactors Learning Management System (LMS). Specifically, they require both the Cost Center ID and its description to be displayed together in a single field. This request presents a challenge as LMS typically handles such data in separate fields or relies on specific formatting or configuration for combined values. The issue involves determining a feasible way to capture and display both pieces of information within the limitations of the LMS user profile structure.
Issue Identified:
The LMS user profile currently does not support displaying both the Cost Center ID and Cost Center description in a single field by default. This limitation makes it difficult to meet the client's requirement of combining both values for better clarity and reporting. A custom approach or configuration may be needed to concatenate and display both elements in one field within the LMS.
- Troubleshooting Steps
I followed a step-by-step approach to diagnose and fix the problem:
Step 1: Verify Source Fields Availability
- Action Taken:
Confirm that both Cost Center (ID) and Cost Center name (Description) fields are available in the Corporate data model.
Step 2: Open the Integration Center Job
- Action Taken:
Navigate to Admin Center > Integration Center > My Integrations.
Open the existing LMS user data export integration job
Step 3: Add Cost Center Field
- Action Taken:
Use the "Insert Fields" tab in the integration builder to add the field
Click "Add" button and named the field as “CUSTOM01”
Step 4: Create a Calculated Field
- Action Taken:
In the Integration Center job:
Add a calculation on the new field.
Find Field Starting from Employment details and Add association Selected Field
Use Concatenate function to combine Cost Center (name) and Cost Center (Code)
Example format attached below:
Step 5: Preview data and Save the Job
- Action Taken:
Use the Preview tab in Integration Center to ensure the concatenated output appears correctly for test users.
Go to the Save button and Click on Save
Step 6: Map the Calculated Field to LMS
- Action Taken:
Identify an appropriate custom field in LMS (e.g., field number 10) and give the name like COST CENTER that can store the combined Cost Center data.
Navigate to Learning Administration > Custom Fields > User
- Map the newly created calculated field to that LMS field in the CONNECTOR Configuration
Navigate to Learning Administration > Configuration> System Configuration > Connectors
Step 7: Run the Integration Job (Test Mode)
- Action Taken:
Run the integration in test mode with a few sample records.
Ensure the custom field in LMS is updated with the combined Cost Center value.
Step 8: Verify in LMS
- Action Taken:
Log in to the LMS admin interface and navigate to the user profile.
Confirm that the custom field (e.g., Custom01) displays the Cost Center in the desired format (ID + Description). - Note: If the result does not match the client’s expected format, update the calculation logic in Integration Center accordingly.
Step 9: Deploy to Production
- Action Taken:
Once tested successfully, schedule or deploy the integration job to production.
Monitor the first run for data accuracy and integrity.
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
