SAP Knowledge Base Article - Public

2537517 - Howto Add a Dynamic Date Range Filter to a Report an Ad Hoc Report

Symptom

  • How to a dynamic filter to a date field, e.g.  report needs to pull data from the past week without setting hard/static date filters in the report definition

Environment

SAP SuccessFactors Workforce Analytics

Resolution

It is not possible to add a dynamic date range in the Report - Table or Ad Hoc reporting.  The closest thing is to make the specific date field that you want to use "User-prompted".  To do this just tick the User-prompted checkbox beside the filter definition in the filter screen selection so that the user running the report is free to enter a specific date range.

Another workaround is to use report type Report - Canvas or the Online Report Designer and report from Live Date. Here it is possible to set a custom dynamic value for date filters in the Filter Designer

Keywords

dynamic date filter, Ad Hoc, ORD, Report - Table date filter, Report - Canvas date filter, flexible date filter, data from the past week, data for the past month, data for the past year , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Core 1708