Past Period Actuals (Stored Period Performance) Data Is Not Available In Data Warehouse / Analytics
(Doc ID 2446305.1)
Last updated on SEPTEMBER 25, 2019
Applies to:Primavera Analytics Cloud Service - Version 126.96.36.199 and later
Primavera Analytics - Version 188.8.131.52 and later
Primavera Data Warehouse - Version 184.108.40.206 and later
Information in this document applies to any platform.
In the P6 Extended Schema (by default, PXRPTUSER) Resource Assignment Actuals can be found in the P6RESOURCEASSIGNMENT / P6RESOURCEASSIGNMENTSPREAD views. The Actuals in these views are spread based on the assignment dates. However, if you are storing Actuals as Period Actuals, also known as stored period performance, these are stored in the P6RESASSIGNMENTPERIODACTUAL view in which it stores Actuals by Resource Assignment and Financial Period. The data from P6RESASSIGNMENTPERIODACTUAL does not map into Data Warehouse preventing Analytics reporting on Period Actual data.
Period Actual data (stored period performance from the P6RESASSIGNMENTPERIODACTUAL view) should map to the Data Warehouse for Analytics reporting.
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