Using report stories for people analytics for creating dazzling dashboards and reports from LMS data

[DavidRod]

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:

1. Create report in LMS or use standard report


2. Schedule the report export to SFTP

Secondly in EC module:

3. Create custom MDF object to hold the LMS report data


4. Make the custom MDF reportable

Thirdly in Integration Center:

5. Create integration job to load the LMS report data to the newly created custom object

And finally, in Report Stories:

6. Create Report Stories


7. 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.