Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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

Paste multiple values in DV filters

Duplicate
301
Views
4
Comments
Adrian Nedelcu-Oracle
Adrian Nedelcu-Oracle Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server Idea Lab

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:

Tagged:
11
11 votes

Duplicate · Last Updated

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.

Comments

  • Marcelo Finkielsztein
    Marcelo Finkielsztein Rank 6 - Analytics Lead

    @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
    Cathye_Pendley Mod

    @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.

    image.png


    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:

    image.png

    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.

    image.png

    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
    Seth Hobbes Rank 2 - Community Beginner

    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
    Benjamin Arnulf-Oracle Admin

    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.