OBIEE 11g - "[nQSError: 22023] An arithmetic operation is being carried out on a non-numeric type"
(Doc ID 2021117.1)
Last updated on FEBRUARY 19, 2019
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.0  to 18.104.22.168.0 [Release 11g]
Information in this document applies to any platform.
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"
[nQSError: 22023] An arithmetic operation is being carried out on a non-numeric type.
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