OBIEE 11g - BIN In Answers Gives Error 'Nonexistent column:' xxxx When Using Another Analysis From A Different Subject Area (Doc ID 2065359.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

When using BINS which point to a different Subject Area than the current Subject Area being reported on in OBIEE 11g, you see the following error message :

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27045] Nonexistent column: "Sample Targets Lite"."Orders"."Order Type". (HY000)
SQL Issued: SELECT 0 s_0, "Sample Targets Lite"."Products"."Brand" s_1, CASE WHEN "Sample Targets Lite"."Products"."Product" IN (SELECT saw_1 FROM (SELECT "Sample Targets Lite"."Products"."Product" saw_0,"Sample Targets Lite"."Orders"."Order Type" saw_1,"Sample Targets Lite"."Base Facts"."Revenue" saw_2,DESCRIPTOR_IDOF("Sample Sales Lite"."Products"."Product")saw_3 FROM "Sample Sales Lite")nqw_1) THEN 'Others' ELSE "Sample Targets Lite"."Products"."Product" END s_2, DESCRIPTOR_IDOF("Sample Targets Lite"."Products"."Brand") s_3, "Sample Targets Lite"."Base Facts"."Target Revenue" s_4 FROM "Sample Targets Lite" FETCH FIRST 65001 ROWS ONLY

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms