DWH View not updated when Attribute updated through XOG

Products

• Clarity PPM SaaS

Issue/Introduction

The DWH Incremental job was showing the wrong lookup value for the attribute (lookup A)

Environment

16.3 +

Cause

The associated custom attribute was originally associated with dynamic lookup A. Lookup A was using using query of table A for the values.

Through XOG or some other type of update, the associated lookup was changed to lookup B.  Lookup B query  was using table B for the values.

The associated view that feeds the DWH, in this case dwh_dw_investment_v, did not update to the correct lookup(B) query and was still referencing lookup A query.

Resolution

Exclude the associated attribute from the data warehouse

Run dwh full load

Include the attribute back for dwh (this will update dwh_dw_investment_v to use the correct lookup.

Run full load again.