My Oracle Support Banner

OBIEE Report Throws NQSERROR: 46008 SQOIMDXGeneratorHyperion.cpp When created Logical Column with IfNull (Doc ID 2632295.1)

Last updated on JANUARY 31, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

OBIEE 12c Version: 12.2.1.4.0
Essbase Version: 11.1.2.4 ASO Cube Unicode

Created Logical Dimension Column using nested ifNull.

Example:

ifnull("BUS_Mod"."Logical_Table"."Gen9,COLUMN500" ,
ifnull("BUS_Mod"."Logical_Table"."Gen8,COLUMN500" ,
ifnull("BUS_Mod"."Logical_Table"."Gen7,COLUMN500" ,
ifnull("BUS_Mod"."Logical_Table"."Gen6,COLUMN500" ,
ifnull("BUS_Mod"."Logical_Table"."Gen5,COLUMN500" ,
ifnull("BUS_Mod"."Logical_Table"."Gen4,COLUMN500" ,
ifnull("BUS_Mod"."Logical_Table"."Gen3,COLUMN500" ,'COLUMN500' ) ) ) ) ) ) )

ERROR
-----------------------
Query Status: [nQSError: 46008] Internal error: File server/Query/Optimizer/ServiceInterfaceMgr/SIMDB/Src/SQOIMDXGeneratorHyperion.cpp, line 5873. [[
[nQSError: 43119] Query Faile

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.