OBIEE 11g - "[nQSError: 42015] Cannot function ship the following expression: AggrExternal" After Patch Update From 11.1.1.6 to 11.1.1.7 (Doc ID 1949744.1)

Last updated on MARCH 28, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.1 and later
Business Intelligence Answers Option - Version 11.1.1.7.1 and later
Business Intelligence Interactive Dashboard - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

Query Failed: [nQSError: 42015] Cannot function ship the following expression: AggrExternal(CW_ICIS.Revenue by [ CW_ICIS.Gen5,Organization, CW_ICIS.Gen2,Years, CW_ICIS.Gen4,Period - Member Key, cast(case when CW_ICIS.Gen4,Period = 'Jan' then cast(CW_ICIS.Gen2,Years as VARCHAR ( 10 )) || '01' when CW_ICIS.Gen4,Period = 'Feb' then cast(CW_ICIS.Gen2,Years as VARCHAR ( 10 )) || '02' when CW_ICIS.Gen4,Period = 'Mar' then cast(CW_ICIS.Gen2,Years as VARCHAR ( 10 )) || '03' when CW_ICIS.Gen4,Period = 'Apr' then cast(CW_ICIS.Gen2,Years as VARCHAR ( 10 )) || '04' when CW_ICIS.Gen4,Period = 'May' then cast(CW_ICIS.Gen2,Years as VARCHAR ( 10 )) || '05' when CW_ICIS.Gen4,Period = 'Jun' then cast(CW_ICIS.Gen2,Years as VARCHAR ( 10 )) || '06' when CW_ICIS.Gen4,Period = 'Jul' then cast(CW_ICIS.Gen2,Years as VARCHAR ( 10 )) || '07' when CW_ICIS.Gen4,Period = 'Aug' then cast(CW_ICIS.Gen2,Years as VARCHAR ( 10 )) || '08' when CW_ICIS.Gen4,Period = 'Sep' then cast(CW_ICIS.Gen2,Years as VARCHAR ( 10 )) || '09' when CW_ICIS.Gen4,Period = 'Oct' then cast(CW_ICIS.Gen2,Years as VARCHAR ( 10 )) || '10' when CW_ICIS.Gen4,Period = 'Nov' then cast(CW_ICIS.Gen2,Years as VARCHAR ( 10 )) || '11' when CW_ICIS.Gen4,Period = 'Dec' then cast(CW_ICIS.Gen2,Years as VARCHAR ( 10 )) || '12' end as DOUBLE PRECISION ) , CW_ICIS.Gen4,Period || ' ' || CW_ICIS.Gen2,Years] ). (HY000)

 



Changes

You have recently upgraded from OBIEE 11.1.1.6 to OBIEE 11.1.1.7.x

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