There is a capability in the latest versions of Clarity PPM (as of version 15.8.0), to create "Custom Investment Type" objects, using the "Investment Extension" that can be primarily used in the Modern UX. The records created for these objects are being loaded into the DWH like any other Investment object records.
The names of these Custom Investment Type objects is however missing in the DWH. Their IDs are present. A sample screenshot below.
Environment
Latest Version: 15.8.0
Cause
Column "Investment Type" of table "DWH_INV_INVESTMENT_LN" is being loaded with NULL.
Resolution
The workaround here is to use the "Investment Type Key" instead of the "Investment Type Name" for filtering purposes.