How do I stop false duplicate results in Report Centre Story reports when using LMS data?

[Loren-Austin]

I have created several reports with the new functionality in Report Centre for People analytics (creating story reports with LMS data). However, every report has duplicates in that are false data.

ie a report of evaluation results is showing that the same user answered all possible options for a single choice answer question, where they only selected one when a canvas report is used to generate the same data.

It appears the data is pulling through every choice label rather than just the one the user selected. How can I resolve this?

[Romanin]

Hi 9415687, I hope you are doing well.

Sometimes this behavior can can be identified as JOIN Clause, as INNER, LEFT, RIGHT, UNION, etc...
Basically when you are making a query and it involves two or more table, is common the results bring duplicate entries.

In this article you can read more about >> https://www.sqlshack.com/learn-sql-inner-join-vs-left-join/ the JOIN clause.

However, you can try one of this approach informed in these KBAs:
2283071 - Duplicated rows on the Adhoc reporting / Report Table - SAP ONE Support Launchpad

2280253 - Hide Duplicate Rows function in Online Report Designer (Canvas) - SAP ONE Support Launchpa...

2250286 - Duplicate Records in Canvas Report - Advanced Reporting - Data Validated - SAP ONE Support...

I hope this helps
Regards
Daniel Romanin