Project History Subject Area Data Not Up-To-Date In Data Warehouse

(Doc ID 2419949.1)

Last updated on JULY 06, 2018

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
In P6 EPPM, projects are showing a particular value for "BL Duration" and "Variance - Duration" which do not reflect the same values within Data Warehouse.

Example:

In P6 EPPM

In Data Warehouse / Analytics:



EXPECTED BEHAVIOR
-----------------------
For BL Duration & Variance - Duration in Data Warehouse to match the associated values within P6 EPPM.

Example:

In P6 EPPM

In Data Warehouse / Analytics (should be):



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

  1. Login to P6 EPPM
  2. Publish a project
  3. Execute an ETL for data warehouse
  4. Note the data discrepancy within Analytics

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