Oracle Analytics Publisher

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

what are the values passed to dataset in parameter multiple selection in BIP report

Received Response
51
Views
6
Comments

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @User_G1EP3 - If you are looking to find the parameters configured in a dataset within a BIP report, please refer to the documentation below for the navigation path:

    https://docs.oracle.com/middleware/12213/bip/BIPRD/GUID-2EE979EC-D88B-4B70-B15B-AF887B499BD6.htm#BIPRD-GUID-F5F8BC93-8FD5-40E6-81EA-E640012123A9

  • User_G1EP3
    User_G1EP3 Rank 1 - Community Starter

    I have a requirement to pass multiple values of paramter in dataset. The values are from fixed data LOV like 0-30,6-21,0-5 etc. I have no option to use IN clause. so I am using REGEX to split it into multiple values.

    Ex: If user selects 0-30,6-21, I want to split that into 2 rows (first row 0-30 and second row 6-21).

    Below code is working for hardcoded values.

    SELECT TRIM(REGEXP_SUBSTR('[0-30,6-21]', '[^,]+', 1, LEVEL)) AS value
    FROM dual
    CONNECT BY REGEXP_SUBSTR('[0-30,6-21]', '[^,]+', 1, LEVEL) IS NOT NULL

    But it is not working for parameter. I used below query in dataset.

    SELECT TRIM(REGEXP_SUBSTR(:P_buckets, '[^,]+', 1, LEVEL)) AS value
    FROM dual
    CONNECT BY REGEXP_SUBSTR(:P_BUCKETS, '[^,]+', 1, LEVEL) IS NOT NULL

    So I would like to know how the values will be passed to dataset in case of multiple selection.

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    Multiselect parameters pass a comma separated list of values wrapped in parenthesis and square brackets.

    Ex: ([value1, value2, value3]).

    Rgds,

    Kevin

  • User_G1EP3
    User_G1EP3 Rank 1 - Community Starter

    I kept the logic based on ([value1, value2, value3]) only. But it is not passing it.

    Please try below query. P_BUCKET displaying NULL

    select :P_BUCKETS from dual

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    Test the LOV SQL as a dataset.

    What does it return?

    Rgds,

    Kevin

  • User_G1EP3
    User_G1EP3 Rank 1 - Community Starter

    I am using fixed data lov as shown below