OBIEE 11g - "[nQSError: 22023] An arithmetic operation is being carried out on a non-numeric type"

(Doc ID 2021117.1)

Last updated on AUGUST 09, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

When you create a prompt on year dimension with SQL :

SELECT "Time"."Year" FROM "Human Resources - Workforce Profile" WHERE "Time"."Year">= VALUEOF("CURRENT_YEAR")-2 AND "Time"."Year"


ERROR
[nQSError: 22023] An arithmetic operation is being carried out on a non-numeric type.

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