I am creating a benefit plan adhoc view. The Benefit plan has cost till 2022. However, on creating the adhoc view in Jaspersoft report (using Financial Management domain), the data for Benefit plan is appearing only till 2020. How can I change this? Why it shows till 2020?
This might be due to fiscal time periods.
If your system have multiple fiscal time periods and dwh need only one for reporting which is defined in system options.
If you can check for this possibility.
I checked system options and entity was mentioned there and type as "monthly". In entity all time periods (including "monthly") are defined till 2022.
Not sure, why jasper is fetching data till 2020 only.
Please check slice configuration.
Yes, Please check for your slices if they have sufficient count on "monthly" slice and are not limiting your data.