Names of Custom Investment Type objects missing in DWH/Advanced Reporting
search cancel

Names of Custom Investment Type objects missing in DWH/Advanced Reporting

book

Article ID: 192424

calendar_today

Updated On:

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.

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.