Business Process Analysis Which Joins Vendor Objects Returning No Results and Data Warehouse Fact Tables (For Example W_BP_LINE_F) Not Displaying/Populating the Correct VENDOR_WID Value

(Doc ID 2340606.1)

Last updated on DECEMBER 19, 2017

Applies to:

Primavera Analytics Cloud Service - Version 17.7 and later
Primavera Data Warehouse - Version 17.7 and later
Primavera Analytics - Version 17.7 and later
Information in this document applies to any platform.



The VENDOR_WID column in table W_BP_LINE_F is not being populated by the W_VENDOR_D.ROW_WID column correctly.  In the W_BP_LINE_F table, it appears that the VENDOR_WID column is being populated with a value of 1, instead of the actual dimension table's row_wid.


For the VENDOR_WID of the W_BP_LINE_F fact table to be populated with the proper row_wid of the W_VENDOR_D dimension table.


The issue can be reproduced at will with the following steps:
1. Execute an ODI ETL against Unifier data source with BPs / Vendors
2. Execute the following SQL which shows the column is not being set properly:
    select vendor_wid, count(1) from W_BP_LINE_F
    group by vendor_wid;


This issue will result in any analysis from Business Process which joins to objects from the W_VENDOR_D dimension table to not return results within OBIEE / Primavera Analytics.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms