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 15.1.0.0 and later
Primavera Data Warehouse - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Using Primavera Analytics connecting to a P6 EPPM source:

When attempting to display results of an analysis that includes:

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

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


STEPS TO DUPLICATE
-----------------------
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.

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