Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Oracle Analytics Cloud - OAPublisher Parameter Issue on Snowflake Data Source

Question
6
Views
0
Comments

We have a data model off of a Snowflake data source that is working without issue except in one particular case: selecting all parameter values.

The Data Model uses our standard code method - (FIELD IN (:PARAMETER_NAME) OR 'All' IN (:PARAMETER_NAME))

However when we run the report and select All, nothing returns.

If we manually select the entire LOV, it works.

Any ideas?