Allow Selection of Multiple Values from an LOV into a single parameter

StevenK

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

The MathWorks, Inc.

Description (Required):

In development of a custom Data Model and Report the user can create a "menu" based parameter that allows them to select multiple values to pass through to the data model and report. User can select one, some or all values using the menu when running the OTBI Report.

When creating an ESS Job, the user has the option to use a custom (or seeded) LOV as a Choice List or List of Values. In both cases, when running the report via ESS Job, the user is limited in being able to select only a single value to pass through to the report.

Use Case and Business Need (Required):

Users often have the need to run a report based on multiple inputs into a single parameter. Due to security concerns we use an ESS Job to facilitate the running of the report but users are limited to passing a single value through any one parameter. We need the ability to select multiple values per LOV/Choice List in any one ESS Job into any one parameter.

Enhancement Request / Service Request:

JimVT

We have the same requirement.

Prashant_Katte

we want the same functionality

User_YBCVZ

we want the same functionality

Vmp

Do you have any update on this selecting multiple values in single parameter? We have a business requirement selecting various values from ESS job parameter LOV

Jayant Ajayrao Deshmukh

To allow users to select multiple values for a parameter in an ESS (Enterprise Scheduler Service) Job in Oracle Cloud, while currently limited to selecting a single value for List of Values (LOV) parameters, a workaround may involve changing the design approach.

Possible Solution:

• Concatenate Multiple Values: A common method is to concatenate multiple selected values into a string, passing that through a single parameter. On the data model side, you can split this concatenated string and process the individual values accordingly.
• Custom LOV Setup: Instead of relying on a single-selection LOV, create a custom logic within the ESS Job to handle multiple inputs passed as a comma-separated string or in another format.

Steps:

1. Modify ESS Parameter: Change the parameter to accept a string that allows for multiple values.
2. Modify the Data Model: Use SQL or PL/SQL logic in the data model to split and process the string containing multiple values.

This approach helps overcome the single-selection limitation in ESS jobs while maintaining flexibility in report generation.

Sidshah

We have the same requirement. Any updates on this ?