Not Able To See Historical Data In Primavera Analytics

(Doc ID 2319172.1)

Last updated on OCTOBER 25, 2017

Applies to:

Primavera Analytics - Version 16.2.0.0 and later
Information in this document applies to any platform.

Symptoms

On Primavera Analytics, after deleting a resource from an activity in P6 EPPM, and after assigning a new resource in P6 EPPM, the result is that the deleted resource name and time-sheet hours do not appear in the Analytics report.

The expected behavior is to see all the historical data in the report for your Resource Assignment.

STEPS TO REPLICATE
------------------------

  1. Deleted resource from the activity and assigned new resource.
  2. Submitted hours in timesheet against the activity.
  3. Approved the resource timesheet hours in P6.
  4. Ran apply actuals to update the actuals hours on the resource assignment.
  5. Published Global Schedule Services.
  6. Published the project.


In STAR:
----------

  1. Run STARETL to move the data into STAR schema.
  2. Attempt to view a report in OBIEE.
  3. Created a new analysis using 'Primavera - Resource Assignment History' Subject Area.
  4. Select Result tab.
  5. Notice that no deleted resource name and timesheet hours appears in the report.

 

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