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