search cancel

Data for parameterized lookup with PRCODE parameter is not populated in DWH

book

Article ID: 144265

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

An attribute that is based on a Parameterized Lookup with PRCODE as a Parameter is populated with NULL values in the Data Warehouse (DWH). 

Including a Parameterized Lookup with @WHERE:PARAM:USER_DEF:STRING:[email protected] populates null values in DWH Captions attribute. 

STEPS TO REPRODUCE:

  1. Login to Clarity.
  2. Navigate to Administration -> Studio
  3. Create a new Object with ID z_cust_obj.
  4. Add the Object Related rights to the user
  5. Create instances with Name and ID ranging from Test1 - Test10.
  6. Navigate to Administration -> Lookup
  7. Create a new Dynamic Lookup.
  8. Under the query section use the below query:

    SELECT @SELECT:ID:[email protected],
    @SELECT:CODE:[email protected],
    @SELECT:NAME:[email protected],
    @SELECT:LAST_UPDATED_DATE:[email protected]
    FROM   ODF_CA_Z_CUST_OBJ
    WHERE  @[email protected]
    AND
    CODE=(CASE WHEN (@WHERE:PARAM:USER_DEF:STRING:[email protected] = 'PR1016' OR @WHERE:PARAM:USER_DEF:STRING:[email protected]='PR1009') THEN 'Test10'
    ELSE CODE
    END)

  9. Navigate to Administration -> Studio -> Investment Object
  10. Create a new Attribute.
  11. Map the Lookup created in Step 7 to the new Attribute.
  12. Include the Attribute for DWH.
  13. Run the DWH Full Load.
  14. Navigate to Advanced Reporting and Create an Adhoc-View on Investment Domain.
  15. Add the attribute that was created in step 10  to Adhoc-View.

Environment

Release : 15.6.1,15.7,15.7.1, 15.8, 15.8.1, 15.9, 15.9.1

Cause

This is caused by Defect DE52979

Resolution

Fixed in 15.9.2

Workaround: Remove @WHERE:PARAM:USER_DEF:STRING:[email protected] from the Dynamic Lookup.