In case of fixed date ranges, dates/years are selectable from 1st January of starting year until 31st December of the latest year (subject year) as for the day/year granularity in Report Story.
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
SAP SuccessFactors HXM Suite
Reproducing the Issue
- Create a time filter in report story with fixed date ranges
- You can see that dates are selectable until the end of the latest year fetched in the report:
If the latest date fetched in the report is e.g., Jun 21 2022:
Then, in fixed date ranges, you'll be able to select dates until 31st December of 2022:
- The same can be seen with earliest dates. If you can see dates in the report e.g., since March 3, 2019. Then you'll be able to select days from 1st January 2019:
This is working as expected. In case of fixed date ranges, dates/years are selectable from 1st January of starting year until 31st December of the latest year (subject year) as for the day/year granularity in Report Story.
So, if your report is fetching records as per range March 3, 2019 - June 21, 2022, you will only be able to select years 2019-2022 as for year granularity. As for the day granularity, you'll be able to select dates from Jan 1, 2019 - Dec 31, 2022.
Report story, granularity, year, fixed date range, day , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , How To