Planned Units Does Not Display In Primavera Analytics Burn Down Subject Area And OBIEE Generates Following Error When Displaying Planned Units In A Report - "[nQSError: 14025] No fact table exists at the requested level of detail" (Doc ID 2294932.1)

Last updated on AUGUST 12, 2019

Applies to:

Symptoms

In the Burn Down subject area, under Facts/Units, the column PLANNED UNITS does not display data. The column is not connected to Burndown logical tables like other fields under Facts/Units.

The following error is visible in the report.log file:

ERROR
-----------------------
[2017-07-24T13:07:28.250-04:00] [OracleBIServerComponent] [TRACE:5] [] [] [ecid: e21433b8db332d1a:-7d88c3e5:15d36f270dc:-8000-00000000000da8e6,0:1:113:5] [tid: 41b8] [messageid: USER-52] [requestid: 123b0053] [sessionid: 123b0000] [username: tbrannan] -------------------- Expression 'Planned Units:[DAggr(Fact - Resource Assignment H.Planned Units by [ Dim - Project User Defined Fields HD ID.Project UDF Date 6, Dim - Date.Day Date, Dim - Project HD ID.Project Id, Dim - Project HD ID.Data Date, Dim - Activity HD ID.Activity Id, Dim - Activity Codes HD ID.Activity Code Value 05, case when TimestampDiff(SQL_TSI_DAY, Dim - Date.Calendar Date, Dim - Project HD ID.Data Date) = 0 then 3000 else NULL end ] )]' converted to NULL because [nQSError: 14025] No fact table exists at the requested level of detail: [,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Activity Codes HD ID.Activity Code Value 05],,,,,,,,,[Dim - Project User Defined Fields HD ID.Project UDF Date 6],,,,,,[Dim - Date.Calendar Date, Dim - Date.Day Date],,,,,,,,,,,,,,,,,,,,,,,,[Dim - Project HD ID.Project Id, Dim - Project HD ID.Data Date],,,[Dim - Activity HD ID.Activity Id],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,]. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Dim - Activity Codes HD ID.Activity Code Value 05, Dim - Activity HD ID.Activity Id, Dim - Project HD ID.Data Date, Dim - Project HD ID.Project Id, Dim - Project User Defined Fields HD ID.Project UDF Date 6.

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

1. Login to Analytics
2. Right-click "Analysis and Interactive Reporting" --> Select option to create a new Analysis, choose "Primavera - Burn Down" subject area
3. Expand "Fact - Primavera - Burn Down"
4. Expand "Units"
5. Add "Planned Units" to the list
6. Add additional columns as you see fit
7. Select Results and observe the related error in the OBIEE log + no results displayed for the column.

Cause

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