SAP Knowledge Base Article - Public

2355325 - Detailed Reporting - Live Data - "between" operator missing from filter

Symptom

In Detailed Reporting for Live Data (adhoc schema's), when trying to set a between filter on a date, the "between" operator is not available (missing).

Environment

Production and Preview environments

Reproducing the Issue

Analytics > Analytics > Detailed Reporting

example below uses Event Date as the filter that is being used.

Below is what you would see

KB - filter missing.png

 

Below is what is expected behaviour

KB - with filter operator.png

Cause

This is caused because the date field being used in the filter (in the example give, Event Date) is not configured as a DATE field. Event Date in this example is configured as a text field and therefore the "between" filter operator is not applicable and will not display.

Resolution

Update the data model to make the affected field a DATE type field.

Keywords

KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , Problem

Product

SAP SuccessFactors Workforce Analytics 1402 ; SAP SuccessFactors Workforce Analytics 1511 ; SAP SuccessFactors Workforce Analytics 1602 ; SAP SuccessFactors Workforce Analytics 1605 ; SAP SuccessFactors Workforce Analytics 1608 ; SuccessFactors Workforce Analytics 1207 ; SuccessFactors Workforce Analytics 1210 ; SuccessFactors Workforce Analytics 1302 ; SuccessFactors Workforce Analytics 1305 ; SuccessFactors Workforce Analytics 1308 ; SuccessFactors Workforce Analytics 1311 ; SuccessFactors Workforce Analytics 1405 ; SuccessFactors Workforce Analytics 1408 ; SuccessFactors Workforce Analytics 1411 ; SuccessFactors Workforce Analytics 1502 ; SuccessFactors Workforce Analytics 1505 ; SuccessFactors Workforce Analytics 1508