DWH_PPM_BASELINE_DETAIL empty even though there are baselines

Products

• Clarity PPM On Premise
• Clarity PPM On Premise

Issue/Introduction

Why is the Data Warehouse (DWH) table DWH_PPM_BASELINE_DETAIL empty even though there are baselines in the Clarity system?

Environment

Release : All

Component : CLARITY DATA WAREHOUSE

Resolution

Initially this table was going to be used for additional processing but was never implemented. Therefore the table remains blank.

There are actually 5 tables that remain blank:

• DWH_PPM_BASELINE_DETAIL
• DWH_PPM_SLICE_FACTS
• DWH_PPM_FISCAL_SLICE_FACTS
• DWH_PPM_SLICE_REQUEST
• DWH_PPM_WIP_FACTS

Additional Information

Reference also: Load DWH job frequently reported issues