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

book

Article ID: 241571

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity 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.

Cause

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

Environment

Release : 15.9.3

Component : PPMDWH

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