SAP’S REPORT STORIES IN PEOPLE ANALYTICS (formerly known as People Analytics Embedded Edition) becomes the main tool for creating dazzling, interactive dashboards and reports in SAP SUCCESSFACTORS HCM SUITE. While other modules are already embedded in Report Stories as of January 2021, as example Employee Central, Performance & Goals Management, etc., SAP SUCCESSFACTORS LEARNING MODULE (LMS) for instance, is not included presently and is only ROADMAPPED FOR Q2 2021.
In this article, AKT’s Technical Consultant David Rodrig demonstrates a way to satisfy the need of LMS admins and managers to use interactive Learning data dashboards using Report Stories for People Analytics… today!
In essence, this is done by exporting data from standard LMS csv reports to custom MDF object, and then making this object reportable and discovered by Report Stories.
Before you start, make sure you have:
- Full super admin permissions to SAP SuccessFactors suite
- EMPLOYEE CENTRAL and LMS modules are enabled
- Full LMS admin credentials
- Integration Center permissions
- SFTP credentials
- Report Stories and IAS are activated (make sure that you can create reports form standard schema data)
Note: To easily facilitate this, you should have knowledge in EC and LMS modules as well as configuring integrations in Integration Center. Also, you should be familiar with Report Stories.
Here are the steps you should follow:
In LMS module:
- Create report in LMS or use standard report
- Schedule the report export to SFTP
Secondly in EC module:
- Create custom MDF object to hold the LMS report data
- Make the custom MDF reportable
Thirdly in Integration Center:
- Create integration job to load the LMS report data to the newly created custom object
And finally, in Report Stories:
- Create Report Stories
- Manage Team view credentials
Step 1: Create report in LMS or use standard report
You can use the standard LMS reports or create your one with BIRT or ORD tools. in this example we created customized learning history report named “overall Learning status” .
Our custom report looks like that:
Step 2: Schedule the report export to SFTP
Now, schedule the LMS report to be transferred to SFTP.
Step 3: Create custom MDF object to hold the LMS report data
In this step we will create new custom MDF to hold the report data.
In admin center >
Configure Object Definitions click
create new object and configure the new object details.
Note: configure the external code to be auto number
Map the field names according to the LMS report field columns. Note that we use the personID to USER data type.
Step 4: Make the custom MDS reportable
The magic starts in this step. we will make the Custom MDF Objects available for Reporting in Report-Story.
Go to the Admin Center >
Manage Data page.
In
Report Object Configuration Entity type, search for the relevant custom MDF object.
On the right side of the screen, click
Take Action >
Make Correction.
Update
is Root to
Yes.
In the Sub-Domain Schema List section, select the
sub domain schema you want to link with the custom MDF object instance.
In our example we connected the object to 3 Sub-Domain Schemas
Step 5: Create integration job to load the LMS report data to the newly created object
In this step we will schedule an integration job to load the report data to the custom MDF object.
Go to the Admin Center >
integration center.
Click
create and choose
Create New Scheduled CSV File Input Integration.
Search for the newly created custom MDF.
In the configure fields tab select
Upsert Multiple and
Full Purge. Then map the LMS report fields to the MDF objects by dragging the fields from left to right.
Pay attention while mapping the PersonID and Username to the relevant fields in the MDF object.
Please note that you can change the Date format to “yyyy-MM-dd’ by clicking the
Date field >
More field options.
and then
Having completed the above steps, you can check your integration by clicking on
Run Preview Records and then run the full integration.
After the integration finished, you can preview the imported data by configuring export data integration or by
Import and Export Data tool.
Step 6: Create report in Report stories
Create new report by selecting
Reports > Story form the main menu.
Please note that you will not have the option to select story unless you will enabled the Report stories and IAS in your instance.
Search for the new created data schema and drag it to the right
Then build the query by selecting the relevant fields
Step 7: Manage Team view credentials
To use
team view you should add the
Username schema, this will allow managers to see only their subordinate’s hierarchy.
Now, add or edit the
team view filter by clicking filter >
scope filtering >
username
And choose
Manager
Click
preview query or
finish and continue to build your story report.
In Conclusion
In conclusion, we have demonstrated how to use REPORT STORIES IN PEOPLE ANALYTICS (formerly known as People Analytics Embedded Edition) right now to be able to create LMS dashboards. Therefore, you can start using Report Stories for LMS now and not have to wait to create your dazzling dashboards until the Q2 2021 SAP SuccessFactors Release where embedding Report Stories for LMS is currently road-mapped.