3727804 - Duplicate records when reporting on 'Assigned Items' with 'Items Events' tables on Learning (LMS) Story reports

• When creating a Story report using 'Assigned Items' and 'Item Events' tables on the same query, the results are duplicates.
• If using only 'Assigned Item' OR "Item Events' the results are accurate and match with what is maintained on Learning Administration.
• When linking both 'Assigned Items' and 'Item Events' tables on the same query, you receive warning message:
  "Adding Assigned Items (or Item Events) will create multiple many-to-one relationship with its parent table User. For the best performance, we recommend that you wither define a table filter on the individual joined tables or aggregate the results on the individual joined tables."
  
  

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• SAP SuccessFactors Learning
• SAP SuccessFactors HCM Suite

1. Access SuccessFactors;
2. Navigate to Reporting;
3. Select "New" -> Story -> connection 'SAPSFLMS';
4. Generate report using the tables :  User → Item Events, check that the results match with the Learning Administration UI;
5. Now generate a report using table User → Assigned Items,  check that the results match with the Learning Administration UI;
6. Now, Generate report combining the tables : User → Item Events and User → Assigned Items;
7. Compare data in the report. You will see many duplicate records found.

Expected Behavior. 

In the scenario described, where the 'user' applied a left outer join with 'item events' and subsequently another left outer join with 'assigned items'. As a result, the records from the first join are multiplied by the records from the second join. 
As indicated in the screenshot, the SAP Analytics Cloud (SAC) tool has already provided a warning regarding the potential for a Cartesian join due to the configuration of these joins. This warning is intended to help users identify and address such scenarios proactively. We recommend carefully reviewing the joint setup to avoid unintended outcomes. 

It is not recommended joining these two tables on a single query. A better approach would be creating two data sources, one for Item Events and other for Assigned Items. 

If you require any assistance on story reporting creation or consulting-related queries, we recommend contacting your Partner. If you are a Partner, please reach out to Partner Community or SAP Professional Service Team. Reference KBA 3625027 - Support Scope for Consulting questions and Creation of Story Reports, Tiles and Dashboards - SuccessFactors Learning.

• KBA 3625027 - Support Scope for Consulting questions and Creation of Story Reports, Tiles and Dashboards - SuccessFactors Learning
  
• 3412790 - Duplicate records in Story Reports

Story reports, LMS, Learning, SFSFSAPLMS, Item Events, Completed Items, Assigned Items, Duplicates , KBA , LOD-SF-LMS-SAC , Stories for Learning , LOD-SF-ANA-SAC , Stories in People Analytics , Problem

SAP SuccessFactors Learning all versions ; SAP SuccessFactors Platform all versions