Names of Custom Investment Type objects missing in DWH/Advanced Reporting
Article ID: 192424
Updated On: 05-30-2023
Products
Clarity PPM On Premise
Clarity PPM SaaS
Issue/Introduction
Product: Clarity PPM
Modules: DWH; Advanced Reporting; Custom Investment Types.
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.
Modules: DWH; Advanced Reporting; Custom Investment Types.
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.
Feedback
Was this article helpful?
Yes
No
Powered by
