DWH Cost Plan Details Table Not Populating

Products

• Clarity PPM SaaS

Issue/Introduction

The financial cost plan details do not get populated in the DWH database.

The following queries are used to confirm:

select * from dwh_fin_plan_detail  
select sum(actual_cost) from dwh_fin_plan_period_facts

However, the results show no records.

Resolution

Perform the following steps to get the cost plan details data to populate:

1. Navigate to Classic > Administration > System Options > Data Warehouse Options

a. Reset the DWH Entity.

b. Checkmark the following:

• Include Weekly Period Data
• Include Monthly Period Data
• Include Fiscal Period Data
• Consistent Fiscal Periods across Entities
• Include only financial Plan of Record

• Include Sql Curve Data” 
• Enable Instantaneous Sync

3. Run the following jobs in the following order:
a. Time Slicing
b. Time Slicing Sync 
c. full Load DWH