Oracle Communities

Oracle Analytics and AI

Child Item

Paste multiple values in DV filters

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

GSO

Description (Required):

Add ability to paste multiple values in a filter replicating existing feature in SI - ANSWERS.

Use Case and Business Need (Required):

The ability to paste multiple values in a filter would greatly enhance usability of filters in DV. See SI Answer equivalent feature below:

Find more posts tagged with

Duplicate

Analysis and Data Visualization

Status: Duplicate

Comments

Marcelo Finkielsztein

@Adrian Nedelcu-Oracle ,

Hi. I suspect I do not understand your idea.

a) I do not know what "SI ANSWERS" is.

b) in OAC DV, we can write a an expression filter like the following ("Country" is a column in the RPD or in a dataset):

Country IN ('USA', 'Canada', Ukraine')

HTH,

Marcelo

Cathye_Pendley

@Marcelo Finkielsztein,

Thanks for responding, I appreciate you offering an alternative. While using an expression filter will work for some, most of our end users might not find it as user friendly as they would need to make sure they had the syntax correct. See below for a couple of projects, imagine if they needed to paste in 40 values and add single quotes (') and commas ('). I would be concerned about typos. If they wanted to paste in hundreds of projects that would be even more difficult.

An example of this is one need we have end users to limit our prompts to 40 values. For example we have a list of 10K projects and our users want to filter on 40 of them. In Classic they are using the method that @@Adrian Nedelcu-Oracle has show above. The users can literally cut the list of projects out of an Excel list and paste right into edit area of the selected items. If they duplicates, the list will remove all duplicates. See below:

We would like to have a similar capability in OAC DV prompts. Right now they would have to search each one from the list and move it over to the right, see below.

I have many years of experience with OBIEE and OAC and I moved one of my DV workbooks to Classic analysis because I kept having to change the list of users_ids and was much easier to cut and paste the 100 plus users in Classic than using the expression filter.

I hope this helps.

Seth Hobbes

This is a much-needed functionality and being asked for by our end users as we convert dashboards from Answers to DV.

Benjamin Arnulf-Oracle

This is a duplicate of the current idea: https://community.oracle.com/products/oracleanalytics/discussion/9936/having-the-possibility-to-paste-a-list-of-values-in-a-prompt

Please add your vote to the current idea.