Lookup values missing in Advanced Reporting

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

There is an existing custom lookup that is associated with a custom attribute in the Resource object. The custom lookup is of Static List type. The custom attribute is being loaded into the DWH. When a new value is created in the lookup's static list, that value does not get displayed in Advanced Reporting / Jaspersoft (as viewed in an Adhoc report).

Cause

No instance of the Resource object has an association with the newly defined lookup value.

Resolution

Data in the dwh_res_resource table shows the values from the lookup that are selected against the Resource records. Make changes in resource records to select this newly defined value.