Super Contributor.. patrick-sa Super Contributor..
Super Contributor..

Missing data in ETL

Hi ,

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.

Please advise.





1 Reply
Absent Member.. DomPPM Absent Member..
Absent Member..

Re: Missing data in ETL

Hello Patrick,

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.

Best regards,


The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.