"# Of Activities" Metric Column in P6 Analytics Will Show as 0 (Zero) If No Activity ID Is Added to Criteria (Doc ID 2083358.1)

Last updated on DECEMBER 09, 2015

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
"# Of Activities" metric column is showing 0 if no Activity ID criteria. With Activity ID criteria, # Of Activities metric column is showing correct value.

EXPECTED BEHAVIOR
-----------------------
"# of Activities" Metric should have values regardless Activity ID Criteria.


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

  1. Log-in to OBIEE
  2. Click New -> Analytics
  3. Criteria Tab
  4. Add Criteria, Project ID, Project Name from Project Group
  5. Add At Completion Labor Units from 'Fact -Primavera -Activity' -> 'Units'
  6. Add Metrics '#of Activity' and '#of Project'
  7. Click Result tab
  8. You will see 0 in '#of Activity', But if you add criteria 'Activity ID' from Activity group.The value is correct in '#of Activity'



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