SAP Knowledge Base Article - Public

2213265 - Fields which are of 'TIMESTAMP' datatype doesn't have Free Text selector in Filter in Ad hoc reports

Symptom

Date field doesn't have Free Text selector in Filter in Ad hoc reports like other ones.
e.g. cannot enter free-text input from the filter selector when filtering on Last Status Change Date, Form Completed On Date, Approved Date

Environment

  • SAP SuccessFactors Workforce Analytics
  • Ad hoc reporting

Reproducing the Issue

  1. Go to Reporting/Analytics
  2. Reports -> Ad hoc reports
  3. Create report -> Select any domain -> Select the date fields in Column tab
  4. In Configuration tab you can see 'Original Data type' of each field.
  5. Go to Filter tab and try to put filter on one of the date field which has 'TIMESTAMP' data type.
  6. You will get the option to select the dates only from dropdown and there will not be any free text selector.
    2019-01-10_18-56-16.png

  7. On the 'Date Type' fields there will be the option.

    2019-01-10_18-49-25.png


Cause

As per design, free text selectors are available only for those fields which have DATE or VARCHAR as date type. A TIMESTAMP field is not designed to have a free text selector in filter.


      2019-01-10_15-56-43.png

Resolution

There is a workaround of those Date fields which have TIMESTAMP Data type:

  1. When setting up the Filter, please enable the "User-Prompted" checkbox.  During runtime, this will let the user enter a free text for the date field. 

    2019-01-10_18-59-50.png
  2. Run the report and in the parameters under Actions, select Free-Text.  Enter a specific date

Keywords

TIMESTAMP - AD hoc - Adhoc - Date field - Filter - Free TEXT - Approved date - Date Of Birth - Date Of Availability - Date Created - End date if temporary , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HXM Suite all versions ; SAP SuccessFactors Workforce Analytics all versions