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

Advanced SQL filter - passing all column values to presentation variable

Received Response
101
Views
2
Comments
2765583
2765583 Rank 1 - Community Starter
edited Aug 13, 2024 6:04PM in Oracle Analytics Cloud and Server

Hi Everyone,

Hoping all is well and hoping you find a quick min to respond to my question below.

I have a below advanced filter where I am trying to have all column values as a default and/or when I run this report from a dashboard, the below filter on my report is not reading all column values from the dashboard prompt and thus not returning any values.

"employee"."D1 Supervisor Full Name" = '@{sup}{%}' or

"employee"."D2 Supervisor Full Name" = '@{sup}{%}'

I appreciate any solution for this issue.

Thanks,

KK

Answers

  • 2765583
    2765583 Rank 1 - Community Starter

    Hi There,

    Anyone has a min to look into above question and respond? Appreciate your time.

    Thanks,

    Keerthana

  • DTV
    DTV Rank 1 - Community Starter

    Hi,

    I think there is a problem with you quotes. Try this -

    "employee"."D1 Supervisor Full Name" = @{sup}{'%'} or "employee"."D2 Supervisor Full Name" = @{sup}{'%'}

    Regards,

    Divya