3082984 - Missing data in reports generated submitting items as filter

Some items are not present in different standard reports' results when the item filter is used. However, these items exist and can be accessed in the tenant.

1. Log into HCM > Navigate to Learning Administration > Reports >
2. Search for a standard report that has an item filter, such as 'Item List (CSV)', 'Item Summary Data Audit Report (CSV)', 'Item Status', etc. >
3. For the Item filter, click on the blue icon to open the Filter wizard >
4. Search for the required items > they appear in the results as expected > select them as needed >
5. Click on 'Submit Criteria' then on 'Submit Filter' >
6. Notice that the item filter shows the expected number of items previously selected >
7. Click on 'Schedule Job' (then submit the background job) or click on 'Run Report' >
8. The report is executed >
9. Looking at the output, some items are missing >
10. However, when running the same report without the item filter, the previously missing reports are then shown.

This happens with items which IDs have hidden character store in the database. This can happen, for example, when the zero width space (ZWSP) appended in the item ID likely from copy/paste of source when creating the item ID through the UI, or through a connector input file using UTF-8-BOM or other encoding instead of UTF-8.

How to identify if that's the case of the items that are missing from the reports:

1. At Learning Administration > Learning Activities > Items >
2. Make an item search, by typing the affected item ID (please do not copy/paste from elsewhere) and change the search operator to EXACT >
3. Set the Item Status as Both > click on 'Search' >
4. If the item doesn't shown in the results, change the item ID search operator from EXACT to CONTAINS > click on 'Search' again >
5. The item should appear now >
6. Click on 'Download Search Results' >
7. Open the downloaded .csv file in Notepad or similar program > save or change the encoding to see the hidden character >
8. Or open the .csv file in Notepad > copy all the content > paste the it into a Word document (or similar program) > and enable the button to show hidden formatting symbols >
9. Look at the beginning or end of the item ID to see where the hidden character is located.

Currently, there is no way to change an entity's ID. Alternatively, to have a different system behavior, it would be possible to have an enhancement request created for it (as per KBA 2090228), where the Learning Product Management team can further review and assess the requested functionality to be considered in a future release.

Workarounds:

1. Execute the reports by applying different filters and refine the results directly at the downloaded report; OR
2. Check the possibility of having a script executed to have the data fixed, by engaging our SAP Profession Services team (2149831); OR
3. Create a custom report filter to use CONTAINS in item criteria (see Custom Report resources at KBA 2379690); OR
4. Create a custom report to replace the ZWDP (e.g. where this ZWSP character is seen after hyphens):
   
   1. Export the report >
   2. In the filters section of the report query, if there is a cpnt_id then we need to replace it with REPLACE(cpnt_id, '-​', '-')
   3. Reimport it as a custom report.
      
      Example of the filter:
      Actual -
      /** and sc.stud_id       in [UserSearch]
      and (sc.cpnt_typ_id, sc.cpnt_id, sc.rev_dte) in [ItemSearch]
      */
      
      Fix -
      /** and sc.stud_id       in [UserSearch]
      and (sc.cpnt_typ_id, REPLACE(sc.cpnt_id, '-​', '-'), sc.rev_dte) in [ItemSearch]
      */

• Exporting Reports
• Importing Reports
• KBA 2379690 - Custom Report Development and Support - SAP SuccessFactors Learning

sf, sfsf, lms, hidden, character, occult, item, filter, criteria, status, list, audit, report, csv, missing, blank, incomplete, Item List, Item Status, standard , KBA , LOD-SF-LMS-REP , Reporting Data , LOD-SF-LMS-ITE , Items , Problem