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
- Set ‘Time Filter’ to ‘Dynamic Date’ – Today
- Enable ‘Turn selection into prompt
- In Variables check ‘Automatically open prompt when story opens’
- 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.
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