Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OBIEE 12c: nQSError: 14025

1762781Nov 6 2024

Hello everyone,

I created new columns on BMM and Presentation layer on rpd file. But when try run some analysis i had this erro message:

Expression 'CT_IT LC WK Unv Qty:[DAggr(Fact - Retail Inventory Position.CT_IT LC WK Unv Qty by [ Dim - Retail Organization As Is.Loc Number, Dim - Item As Is.Item Level 1 Number, Dim - Item As Is.Department Number, Dim - Item As Is.Item Level 1 Desc, Dim - Item As Is.Class Number, Dim - Date Retail Fiscal Calendar.Fiscal Week, Dim - Date Retail Fiscal Calendar.Week Wid] )]' converted to NULL because [nQSError: 14025] No fact table exists at the requested level of detail: [,,,,[Dim - Item As Is.Item Level 1 Number, Dim - Item As Is.Department Number, Dim - Item As Is.Item Level 1 Desc, Dim - Item As Is.Class Number],,,[Dim - Retail Organization As Is.Loc Number],Fiscal Week,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,]. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Dim - Date Retail Fiscal Calendar.Row Wid, Dim - Date Retail Fiscal Calendar.Week Wid, Dim - Item As Is.Class Number, Dim - Item As Is.Department Number, Dim - Item As Is.Item Level 1 Desc, Dim - Item As Is.Item Level 1 Number, Dim - Retail Organization As Is.Loc Number.
[2024-11-06T11:42:32.813-05:00] [OracleBIServerComponent] [TRACE:5] [] [] [ecid: 000000oKQ2h76EG6yz6iMG00VW0s0003vm,0:2:1:1:5] [tid: 5759] [messageid: USER-48] [requestid: 45ca0010] [sessionid: 45ca0000] [username: LHUDS] -------------------- The logical query block fail to hits or seed the cache in subrequest level due to [[
only one subrequest

Anyone pass for this recently?

Complete log here: https://drive.google.com/drive/folders/1qt2fdpyXvmh0foI8AyFoOcdmpzjhkHF5?usp=sharing

Comments
Post Details
Added on Nov 6 2024
2 comments
26 views