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 SEPTEMBER 23, 2021
Applies to:
Primavera Analytics - Version 16.2.4.0 and laterInformation in this document applies to any platform.
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:
- Login to Analytics
- Right-click "Analysis and Interactive Reporting" --> Select option to create a new Analysis, choose "Primavera - Burn Down" subject area
- Expand "Fact - Primavera - Burn Down"
- Expand "Units"
- Add "Planned Units" to the list
- Add additional columns as you see fit
- Select Results and observe the related error in the OBIEE log + no results displayed for the column.
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! |