BP Data Which Is Not Associated To A Project / Shell Within Unifier Is Not Coming Into Data Warehouse / Analytics Through The ETL

(Doc ID 2358990.1)

Last updated on APRIL 19, 2018

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
After executing a Daily ETL (LOAD_PLAN_DAILY) for a Unifier source, a mapped BP which is not tied to any project/shell within Unifier (but is published/written to the Unifier staging tables) is not being added to the Data Warehouse W_BP_D / W_BP_F tables through an ETL.

Note: 

EXPECTED BEHAVIOR
After executing a Daily ETL (LOAD_PLAN_DAILY) for a Unifier source, a mapped BP which is not tied to any project/shell within Unifier (but is published/written to the Unifier staging tables) should be added to the Data Warehouse W_BP_D / W_BP_F tables through an ETL.

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

  1. Map a BP (which contains data) within Unifier Analytics node (the BP should not be tied to any specific project or shell. For example, a "Project Creation" BP)
  2. Execute a Unifier publication
  3. Execute an Analytics/Data Warehouse ETL
  4. Login to Analytics
  5. Select New > Analysis
  6. Select Primavera - Business Process
  7. Add the BP Name column then click results
  8. Click refresh link
  9. Note that the appropriate BP is not displaying in Analytics


ADDITIONAL INFORMATION
When connecting to analytics using an Administrative role, the following SQL can be executed to confirm the BP is present in the Unifier Staging tables:

select bp_name, count(1)
from sys_stg_bp@dslink02
where project_object_id < 0
group by bp_name
order by 1;

The following SQL can be utilized to confirm that the BP was not written to the Data Warehouse W_BP_D / W_BP_F tables:

select bp_name, count(1)
from w_bp_d
where project_object_id < 0
group by bp_name
order by 1;

select bp_name, count(1)
from w_bp_f
where project_object_id < 0
group by bp_name
order by 1;

Reference: How To Run Direct SQL In OBIEE (Analytics) For Selecting / Analyzing Data Within Data Warehouse, P6 EPPM Extended Schema Or Unifier Staging Tables (Doc ID 2277596.1)

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