My Oracle Support Banner

BICS: Error -"Variables With Multiple Values Are Not Supported in Expression" Encountered When Trying to Set Up Data Filters Using a Variable (Doc ID 2139264.1)

Last updated on NOVEMBER 30, 2019

Applies to:

Oracle Business Intelligence Cloud Service - Version and later
Information in this document applies to any platform.


On Oracle Business Intelligence Cloud Services (BICS) application of version 16.1.x, when trying to set up data filters using a variable (to use multiple values), as in an on-premise application, the following error occurs:

For example - "Entities"."Entity ID" IN (VALUEOF(NQ_SESSION."<datafilter>")) 

"Variables with multiple values are not supported in expression"


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.