Adhoc View Reports- Time Periods

[UrujHW]

Hi,

 

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?

 

Regards,

Uruj

Uruj

[Kritika Rana]

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.

[UrujHW]

Hi Kritika,

 

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.

[Senthil Kumar Lakshmanan]

Hi

 

Please check slice configuration.

 

Thanks

Senthil

[Kritika Rana]

Yes, Please check for your slices if they have sufficient count on "monthly" slice and are not limiting your data.