SAP Knowledge Base Article - Public

3118834 - As Of Date not Updating to Today in Report Story

Symptom

As of Date is not getting updated to 'Today' when 'Turn selection into prompt' is enabled and 'Dynamic Date' is set to 'Today'.

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Set ‘Time Filter’ to ‘Dynamic Date’ – Today
  2. Enable ‘Turn selection into prompt
  3. In Variables check ‘Automatically open prompt when story opens’
  4. The other day when ‘As of date’ pops up, it remains at the date when the data source/report was created

Cause

If 'Turn selection into prompt' is enabled in Time filter, Today's date is not getting updated correctly.


Possible workarounds:

1. Disable 'Turn selection into prompt' and the report will automatically fetch data for the current date 'Today'.

2. Set the date manually to today at every run when it pops up as a run-time filter.

Resolution

This issue is currently under investigation by SAC development.

Keywords

Prompt filter, As of date, dynamic date, today, as of date today, data source, time filter, Turn selection into prompt, Automatically open prompt when story opens , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , Problem

Product

SAP SuccessFactors HXM Core 2111