SAP Knowledge Base Article - Public

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


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


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


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.


This issue is currently under investigation by SAC development.


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


SAP SuccessFactors HXM Core 2111