Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Received Response
23
Views
3
Comments
JPorisVU
JPorisVU Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

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?

Tagged:

Answers

  • RVohra
    RVohra Rank 6 - Analytics Lead

    No experience with Snowflake but see if below works for you:

    • Add an 'All' option with a null or special value, like '@ALL @' .

    Display Value

    Return Value

    All

    @ALL @

    WHERE (:PARAMETER_NAME = '@ALL @' OR FIELD IN (:PARAMETER_NAME))
    This makes it explicit: when @ALL @ is selected , skip filtering.

    I think this pattern is reliable, when data source doesn't gracefully handle ambiguous IN logic with 'All'.

  • JPorisVU
    JPorisVU Rank 3 - Community Apprentice

    @RVohra Unfortunately, that did not work. Selecting the All option still returns no vales. Thank you for the option, though.

  • RVohra
    RVohra Rank 6 - Analytics Lead

    Please check with Oracle Support by logging a SR, Oracle team have more knowledge base and might have seen this with other Users. Otherwise, log an Idea in Idea Lab. Hope it helps!