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.