The Fiscal Data Warehouse Time Slices Are Not Updating

Document ID : KB000037260
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

Why is the Administration, Data Administration, Time Slices page showing the "Expiration" column as outdated and the "Last Run" column as null for the Fiscal Data Warehouse (DWH) slices?

Answer:

This is because the Entity, Fiscal Time Periods for the Data Warehouse Entity have not been activated.

  1. Go to Administration, Finance: Setup, Entity 
  2. Open the Entity that is associated with the Data Warehouse 
  3. Click on 'Fiscal Time Periods' tab 
  4. Create and Activate the Monthly time periods that cover the range of the fiscal DWH time slices set in the Time Slices page  
  5. Run an instance of the Time Slicing job  

Additional Information:

PPM Tech Tip: How should the main PPM jobs be scheduled?
PPM Tech Tip: Getting Jaspersoft Advanced Reporting to work after upgrading to 14.2+

Reference TEC528729 : Configuring and Scheduling some of the main jobs