Running An Analysis In OBIEE Returns 'No Results' When Using The 'Primavera - Activity' Subject Area When Data Is Present In Analytics And You Are Logging Into Analytics With A Username Which Matches A P6 EPPM Username

(Doc ID 2277601.1)

Last updated on JUNE 20, 2017

Applies to:

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


Using Primavera Analytics connecting to a P6 EPPM source:

When attempting to display results of an analysis that includes:

The Analysis results displays the following even though there should be data within Data Warehouse which includes results:

The Analysis results should display data for the project set in filter since valid results should exist based on the assignments within P6.

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

  1. Login to Analytics
  2. Select New > Analysis > Primavera - Activity
  3. Bring over the noted columns to the selected columns
  4. Add a filter where ID=$ProjectId
  5. Select the results tab
  6. Note the exception which occurs.


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