Lookup values missing in Advanced Reporting
search cancel

Lookup values missing in Advanced Reporting


Article ID: 255652


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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).


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


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.