When creating an Adhoc report in CA PPM Advanced Reporting using the Project Total Actual Hours measure, some projects do not show up in the report. If you remove the Total Actual Hours column, the projects then display.
Steps to Reproduce:
It appears this is related to data not populating correctly in the Data Warehouse (DWH) table: DWH_INV_SUMMARY_FACTS as the issue only occurs when the Total Actual Hours measure is included which pulls from this table.
Release: CODFSS99000-15.3-PPM SAAS FedRAMP-Sandbox-Small Environment
This issue is no longer reproducible in CA PPM 15.4.1