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 JULY 17, 2017

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"


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