Fiscal Slices from earlier years not in DWH

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

We are create a new financial report in MUX Reporting and see data discrepancies. Some cost data for 2019 and 2020 is not shown in Data Warehouse. We are looking to cover 2019-2030. How can we make the report display the data. 

Environment

All Supported Clarity Releases

Resolution

1. Connect to Administration - Time Slices
2. Order the slices on FISCAL and DWH enabled
3. Open each slice request in a new window and set the From date to 1/1/2019, number of periods 144, this should cover you until end of 2030.
4. Save, repeat for each DWH Fiscal period, all must have the same From Date and Number of Periods
5. Now run Time Slicing Job to completion, it's likely going to run for a long time so please test this in a lower environment
6. Run Update Report Tables job
7. Run Load Data Warehouse - Full Load
8. Now try again and see if the query indicates min date in 2019. 
   In DWH database:
   SELECT MIN(period_start_date), MAX(period_end_date), COUNT(*)
   FROM   dwh_cmn_period
   WHERE  period_type_key = 'FISCAL';
9. If this looks good, try your report again.