Missing data in ETL
We're running PPM 9.31 and we've set up operational reporting.ETL seems to be running well but we found that the MV RPT_DIM_PM_WORKPLAN_MV is not fully refreshed.We have some missing workplans from this view but when we look at the rpt_dim_requests table,the project associated with the missing workplan is created.
In other words the project was created in the rpt_dim_requests table but its related workplan was not created in the RPT_DIM_PM_WORKPLAN_MV view.
Re: Missing data in ETL
I hope you are doing great today.
Regarding this issue you are having, I would like to suggest to re-run the ETL to see if the issue persists. Also it would be good to check at the database level if the data is in there before doing the ETL to ensure that the data in fact need to be moved through the ETL.