My Oracle Support Banner

Numeric UDFs Not Seen In Unifier Generic Cost Sheet Subject Area (Doc ID 2630233.1)

Last updated on MARCH 05, 2020

Applies to:

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

Symptoms

Note:  Scenario is applicable to Unifier Analytics.

Customer requirement is to show data in an analysis like Project Name, <NumericUDF> (Shell UDF numeric Field), Month Name, CostCode, CostName.
This comes from multiple subject areas and once these are all selected in the criteria, the <NumericUDF> column is empty.

Project Name, Month Name, Costcode and CostName are coming from Subject Area: Primavera - Generic Cost Sheet
<NumericUDF> is coming from Subject Area: Primavera - Project User Defined Fields.

 

Steps to Reproduce

  1. Log into Analytics.
    • New Analysis - Criteria
    • Subject area: Generic Cost Sheet -> project hierarchy - project hierarchy id level2
    • Subject area: Generic Cost Sheet -> project hierarchy - project hierarchy name level2
    • Subject area: Generic Cost Sheet -> project - general - project hierarchy id level2 - datasource id (filter on datasource id=n)
    • Subject area: Generic Cost Sheet -> fact - primavera generic - costs - user defined column 1
    • Subject area: Generic Cost Sheet -> fact - primavera generic - costs - user defined column 2
    • Add 2nd subject area Primavera Project user defined fields
    • Subject area: Primavera Project user defined fields -> Fact Project UDFs - Numeric project shell - <select numeric udf column>
  2. Click Results tab
    • Results will show expected data item(s).
  3. Set a filter to show only 1 item.
    • Results show the numeric UDF data item is populated.
  4. Criteria tab - Add new subject area Generic Cost Sheet
    • Add column. For example: cost code - general - code
    • Results now show a Null value for the numeric UDF column.

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!


In this Document
Symptoms
Cause
Solution
References


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