Oracle Business Intelligence Applications

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

Unable to choose multiple selection of values for a parameter in ESS job

Received Response
34
Views
4
Comments
User_VICIT
User_VICIT Rank 2 - Community Beginner

We have a requirement where we need to select multiple values for a parameter in BI report. When we are trying to create a custom ESS job, we don't see an option to select multiple values from LOV at parameter level.

Is there any option which we can use to select multiple options for a parameter from the ESS job.

Thanks,
Mansi

Tagged:

Answers

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist
    edited Nov 16, 2024 3:30PM

    Hi,

    This is not supported currently.

    Is It Possible To Enable Multiple Selection Setting For ESS Job Parameters (Doc ID 2871349.1)

    There is already an idea submitted, please upvote:

    Enable multi selection parameters in ESS job — Oracle Analytics

    Thanks.

  • User_WBLBP
    User_WBLBP Rank 1 - Community Starter

    We looked into this document and this is pointing to older version. Just want to check if this feature is available in newer version.

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist

    Hi @User_WBLBP ,

    The status is same still i..e multi select is not supported through ESS jobs. Once it is available, the MOS doc which I shared earlier either will get an update or will be archived by Oracle.

    Also, the idea link I shared still doesn't say that the functionality is available. The idea status changes when functionality is delivered.

    I hope this helps.

    Thanks.

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist
    edited Nov 16, 2024 3:31PM

    If you just want to pass multiple values, instead of giving an option to choose multiple values from a list, then you can use the workaround mentioned in below MOS note:

    Fusion Applications - How to Pass Multiple Values in a Single Parameter to Custom ESS Job that Submits Custom BI Publisher Report (Doc ID 2774925.1)

    Thanks.