Oracle Analytics Publisher

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

How to handle 'All' parameters in Oracle BI EE query

Received Response
116
Views
3
Comments

I used this method but it didn't work.

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 8 - Analytics Strategist

    @Salma Ashraf - Does your data have null values as well for Person_number? If yes, that could be the issue, as Oracle BI EE connection doesn't handle NULL values. Please refer below thread where they have suggested how the null values should be handled.

    BI Publisher - Selecting 'All' in Parameter does not return any data

  • Rank 5 - Community Champion

    Hi @Salma Ashraf,

    Could you try like this instead of the SQL statement you used for Person number? Since you use NULL values as passed radio button, I doubt it would pass 'All' back to the query. It will send NULL. Try revising the statement like this and let know if it works.

    AND (person_number IN (:person_number) OR LEAST(:person_number) IS NULL)

    Thanks ,

    Abhilash

  • Rank 1 - Community Starter
    edited May 29, 2024 11:12AM

    Hi @Abhilash K - Deloitte USI

    Oracle BI EE often enforces security restrictions that might prevent using functions like NVL or LEAST directly in the presentation layer.

    also when i put this statement AND (PERSON_NUMBER IN (:person_number) OR 'All' IN (:person_number || 'All')) in my query it gives me this error when i run the query

    Thanks in advance

    Salma Ashraf

Welcome!

It looks like you're new here. Sign in or register to get started.