We run a full run of the data warehouse job every hour for reporting. Recently, the job has resulted in lower than expected numbers for the data warehouse tables (such as : DWH_INV_ASSIGN_PERIOD_FACTS).
We have made everything incompatible with the job and paused every job except for time slicing.
What can help fix this, and is there anything we can run to verify what the counts should be from the transactional database?
Release : 15.8.1
Component : CA PPM SAAS DATA WAREHOUSE
Restart App and BG services
For script options, some queries are available in KB: Data Discrepancies in Actuals, Estimates or Allocation
If on a Clarity version lower then 15.6, see also: Assignments in Report Incorrect: DWH_INV_ASSIGN_PERIOD_FACTS issue