2393145 - How to filter date field using LMS data in Online Report Designer

SAP Knowledge Base Article - Public

2393145 - How to filter date field using LMS data in Online Report Designer

Symptom

When filtering by a date field in LMS,  try and filter for just one day. For example, Start Date equals to 10/11/2016.

equalstoLMS.png

The report will return a message saying ‘No data available. Please Change You Selection’

nodataLMS.png

Environment

All SuccessFactors Environments.

Reproducing the Issue

Create a Learning report in Online Report Designer (ORD). Try to filter by using a date field using the equals to operator.

Cause

The message ‘No data available. Please change your selection’ is caused by the configuration of date fields within LMS. In LMS, the date fields, such as Start Date, are taken from a time stamp which means that by default their format will be in DD/MM/YYYY HH:MM:SS. Although the date in hours, minutes and seconds are not outputted as part of the report, they are saved in the LMS database in this format.

When you are using the equals to operator when filtering,  query looks for an exact date in the database, in the format of DD/MM/YYYY. Therefore, when you filter by a date on a report using Learning Data there are no fields in the date format DD/MM/YYYY causing the report to produce the message saying ‘No data available. Please change your selection.’ 

Resolution

Currently, this is a product limitation within the ORD framework. However, in certain cases there may be a workaround if you are using date fields with a start date and end date when you want to filter to one exact date.

To generate a report for a timeframe of just one day:

  • Set the Start Date to be greater than or equal to the day that you want to run the report for.
  • Set the End Date to be less than the day after the Start Date. 

See screenshot for example: 

LMStimestampworkaround.png

Keywords

LMS, Detailed Reporting, Report Designer, Runtime Filters, ORD. , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-LMS-REP , Reporting Data , Problem

Product

SAP SuccessFactors Learning 1608 ; SAP SuccessFactors Workforce Analytics 1605 ; SAP SuccessFactors Workforce Analytics 1608 ; SAP SuccessFactors Workforce Analytics 1611