My Oracle Support Banner

Project Count Varies When Using A Manual Aggregation Of Project ID Dimension Instead Of Using The "# Of Projects" Fact Column Within A New Analysis From "Primavera - Project History" Subject Area (Doc ID 2389797.1)

Last updated on APRIL 24, 2018

Applies to:

Primavera Analytics Cloud Service - Version 17.11.0.0 and later
Primavera Analytics - Version 17.11.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
When creating an initial analysis from the Project History subject area to display a count of project IDs (using a manual count aggregation of the General - (Project) > Project Id column) (with/without additional columns added to the analysis initially), modifying the analysis and adding additional column(s) cause the manual aggregation count of a dimension to differ from the original values.

For example:


EXPECTED BEHAVIOR
When creating an initial analysis from the Project History subject area to display a count of project IDs (using a manual count aggregation of the General - (Project) > Project Id column) (with our without additional columns added), modifying the analysis and adding additional column should not result in the value to the manual aggregation to differ from the original display.

STEPS TO REPRODUCE
Example Analysis 1:


Example Analysis 2:

Note the discrepancy between the two analysis project ID counts when simply adding a root EPS level column that should not change the project ID count value. 


Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.