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

Unable to select all values in default selection of dashboard prompt

Received Response
1
Views
1
Comments
Chandranshu Bhardwaj
Chandranshu Bhardwaj Rank 3 - Community Apprentice
edited Aug 13, 2024 5:56PM in Oracle Analytics Cloud and Server

Hi,

I have been trying to use SQL query in dashboard prompt. I have used a query for choice list like

SELECT evaluate('Initcap(%1)',TRIM(BOTH ' ' FROM "Core Lease"."Landlord Name")) FROM  "Property" where "Operating Unit Organization"."Operating Unit Country"='Uganda' ORDER BY "Core Lease"."Landlord Name".

The choice list gives the desired vendor names.

But when I use the same query in default selection, only few values gets selected the remaining values remains unchecked.

I can't use All Column values option because I need to use it as Presentation variable

Can anyone let me know if I have to change any specific property or have to do some changes in config files.

Thanks

Answers

  • deeps
    deeps Rank 3 - Community Apprentice

    If you use the presentation variable like this in the report filters, you can set the prompt default to None:

    And  UPPER("Column Name")  like UPPER('%@{pres_var}{%}%')

    See if this helps .