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 AUGUST 06, 2024

Applies to:

Symptoms

Using Primavera Analytics connecting to a P6 EPPM source:

When attempting to display results of an analysis that includes:

• 'Primavera - Activity' Subject Area
  
  • Columns from 'Codes - Project'
  • Columns from 'General'
  • Columns from 'Text UDFs - Project'
  • Project ID filter

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

• No Results
• The specified criteria didn't result in any data. This is often caused by applying filters and/or selection steps that are too restrictive or that contain incorrect values. Please check your analysis filters and selection steps, and try again. The filters or selection steps currently being applied are shown below.

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.
   
   

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.