ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Timesheet User Value 1 (custom lookup) data is NULL in DWH Table DWH_TME_ENTRY_LN


Article ID: 241571


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


We have created the custom User Lov 1 lookup as per the KB however the data is still not in the DWH.


This is caused due to incorrect references of the lookup in DWH_TIMEENTRY_V on PPM Database.


Release : 15.9.3

Component : PPMDWH


  • 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