Business Process Subject Area Does Not Contain Data In Analytics After Running A Unifier ETL

(Doc ID 2386960.1)

Last updated on JUNE 25, 2018

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
-----------------------
When creating a new analysis in Analytics, the BP Dimension area is not showing the correct data. Additionally, after running a Unifier ETL:
The W_BP_DS table is getting populated with the total number of rows from the SYS_STG_BP table, but is not populating any value for majority of the required fields (example, bp_object_id, project_object_id).

 

EXPECTED BEHAVIOR
-------------------------
The ETL should correctly populate the W_BP_D/DS table

 

STEPS TO REPRODUCE
--------------------------
The issue can be reproduced at will with the following steps:

  1. Run an ETL to populate the BP data
  2. Create a new analysis in Analytics using the Business Process subject area
  3. Observe the Dimension data is not populated correctly.

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot report on the business process data correctly.

Changes

 

Cause

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