Business Process Subject Area Does Not Contain Data In Analytics After Running A Unifier ETL
(Doc ID 2386960.1)
Last updated on AUGUST 29, 2023
Applies to:
Primavera Analytics Cloud Service - Version 18.3 and laterInformation 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:
- Run an ETL to populate the BP data
- Create a new analysis in Analytics using the Business Process subject area
- 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |