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

If Parameter binding return NULL values, selection not working as intented.

Received Response
64
Views
2
Comments
Rajakumar Burra
Rajakumar Burra Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

Question related to binding parameter in OAC.

Just come across one use case/issue where Parameter Binding is not working or need improvement.I have the Parameter definition and Bound to one filter. It works fine till Parameter returns some values.
After reaching our milestones, the Parameter doesn't return any values as per Logical SQL Query definition.  So in this case Bound shows no values and selection returns complete column values instead of no data.


Here my expectation is Visualization should show as "No Data"

In OBIEE we used to do with "Logical SQL" in statement which is not available in OAC. We are using Parameter binding as workaround.

image-c891f82c07098-6546.png

Answers

  • GayathriAnand-Oracle
    GayathriAnand-Oracle Mod

    Hi

    Can you please share more details of your parameter and filter setup? Is your parameter definition based of logical sql which might result in no data? And when this parameter is used to restrict filter, since there is nothing to filter by it shows all data, seems expected? Maybe i am not getting your use case right. Please provide more details. Other comments welcomed.

    Thanks

    Gayathri

  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics Lead

    @GayathriAnand-Oracle You are understanding is correct. Also we can assume it as expected behavior for OAC. But my expectation is here is, if it is bind with parameter and results no data, it should show as "No result".

    Actual my use case is below which we used to do in OBIEE classic.

    We used to filter columns based on other Analytics in OBIE. We used to do in two way.

    • Using operator Based on results of another Analysis [Please see image]
    • Filter the value using Edit Expression. Here we use "SELECT" function. [Please see image]

    In above both cases if result in no data, it will show as "No Result"

    Since OAC missing above two options, we are using workaround as "Parameter" Binding. Since logical SQL results in no data , it is showing complete column data.

    Hope you understand my usecase.

    OBIEE column filter options.

    image.png image.png