Oracle Transactional Business Intelligence Idea Lab

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

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

2
Views
0
Comments
StevenK
StevenK Rank 2 - Community Beginner

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:

1
1 votes

Submitted · Last Updated