Piloting a project with a cost plan out to 2023-Q2. (we have very long projects...)
When building adhoc report in Jaspersoft, it only returns data out to 2021-Q1.
Q: How to extend DWH time periods to include, at least, through the end of our planned projects?
It appears the periods in the DWH are only going out to 2021-Q1.
Would you please check the 13 FISCAL type slices in the Time Slices page and check the From Date and then count the Number of Periods to see if that goes through 2021-Q1?
I use the calculator at Calculator: Add to or subtract from a date.
If this returns a similar date you will need to add more periods to your FISCAL slices to increase the range.
Once done, let the time slices complete then run
Update Reports Tables with Calendar Option
Load DW - Full Load
Thank you. This will probably do the trick. With the slice names prefixed with ‘baseline,’ ‘allocation,’ ‘assignment,’ ‘team’….wasn’t sure which, if any, were pulling from cost plans.
Will reviewing with team whether to extend Number of Periods or pull From date ahead, or both.
Will get back and indicate ‘correct answer’ when successful, probably in next week or two.
Check out the following documentation. They might be helpful:
Configure the Data Warehouse and Advanced Reporting Domains
Configure Time Slices