Timesheet User Value 1 (custom lookup) data is NULL in DWH Table DWH_TME_ENTRY_LN
book
Article ID: 241571
calendar_today
Updated On:
Products
Clarity PPM SaaSClarity PPM On Premise
Issue/Introduction
We have created the custom User Lov 1 lookup as per the KB https://knowledge.broadcom.com/external/article/22205/userdefined-lookup-with-time-entry-user.html however the data is still not in the DWH.
Environment
Release : 15.9.3
Component : PPMDWH
Cause
This is caused due to incorrect references of the lookup in DWH_TIMEENTRY_V on PPM Database.
Resolution
Navigate to Administration -> Timesheet Options.
Change the Lookup for User Value 1 to the default lookup and Save.
After the save is complete, revert the change to the custom Lookup and Save.
Validate the data by running a query against DWH_TIMEENTRY_V on PPM database. Ex :- select user_value1_caption from dwh_timeentry_v