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
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