SAP Knowledge Base Article - Public

3263179 - Change of column configuration from Timestamp to Date does not reflect in Runtime filter in Table reports

Symptom

Change of column configuration from Timestamp to Date does not reflect in Runtime filter in Table reports


Environment

SAP SuccessFactors HXM Core

Reproducing the Issue

1. Change a timestamp field configuration to Date in Table report in Report Center

2. Run a the report with the field selected in Runtime filter in Report Center

3. Go to Actions menu of the date field

4. Choose „Free-Text” option

5. Enter any date in date format

6. After generating the report see that the report is empty


Resolution

The change of configuration of a column from Timestamp to Date will reflect only in report output and not in other places like runtime filter selections. 

The free-text for the Timestamp column will always consider Date with Timestamp as 00:00:00 and this free-text will work correctly for By-Rule selection with greater than, less than, greater than or equal to and less than or equal to.

In By my selection, data with free-text filter will always be null until there is a match in database with timestamp 00:00:00.

This is an expected behaviour.

Keywords

Report Center, Reporting, Table, Table report, Ad hoc, runtime filter, report, blank, empty, does not fetch, timestamp, date, format, last modified on , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem

Product

SAP SuccessFactors HXM Suite Core 2205