I would like to ask you about any experience with increasing range of periods to DWH for Benefit plans. We are facing issue that We have a project with long term benefits but see benefits in DWH until 2020 and no more. We increased DWH time slices but seems that it did not help us as we expected. No change. Any experience with this and any recommendation, please?
Did you get any chance to look into the below details mentioned about DWH Time Slices
Configure the Data Warehouse Time Slices
Time slices with the Data Warehouse option selected determine the ranges for the Data Warehouse facts. Data Warehouse time slice requests are system requests and cannot be deleted.
The Data Warehouse time slice requests default to the following time periods, which are based on the database server system date:
Three years back and forward for Fiscal. The From Date is three years before the system date. The From Date is the start date of the fiscal period for the entity that is selected for the Data Warehouse. The fiscal period that is referenced is of type Monthly or 13 Period, whichever is set for the entity.
Verify that the ranges work for your business needs. If necessary, you can update the From Date and Number of Periods by opening a time slice and changing the properties.
Please ensure your fiscal periods go beyond 2020, if they don't, you will not see the financial data after this point.
Once you add more open fiscal periods, please run a Load DWH - Full until completion.
Please try this and let me know if that works.
Hope this helps -Nika
Hello Nika, thank you for your reply. But problem is that we have open fiscal periods over 2025. So as I understand how it works then we should see financial data to last open fiscal period we have opened. DWH weekly slices were set up to reach those periods as well. Then we ran full load DWH JOB but still do not see it. Any other suggestions what could help to make it working? I have to mention that for PRE-PROD environment worked fine. Thank you Lukas
I see, this is odd. Please try the following solution to reset the Data Warehouse slices:
Hope this helps.
Thank you -Nika
Hello Nika, thank you for your valuable tips how to solve this. Finally we had to find out which DHW time slice includes requested data. I have not found any kind of definition of DWH timeslices, anyway it is working for now. Do you have any idea where DWH timeslices are documented in a way what data are preparing during DWH load perspective?thank you a lot
Great to hear the issue is now solved!
Please check out this documentation, see if that helps answer your additional questions:
Hope this helps -Nika