Oracle Analytics Cloud and Server Idea Lab

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

Having the possibility to paste a list of values in a prompt

Planned
823
Views
31
Comments

Organization Name

Terlato Wines

Description

Having the possibility in DV to paste a list of values directly inside a prompt. Similar to the "edit" list icon in OBIEE classic prompt. This is required for analysts who need to copy a list of invoice numbers for example and paste it into a prompt.

Use Case and Business Need

For example we would need to have an option to copy and paste a list of countries instead of manually select them one by one.

Original Idea Number: 1b77a132c6

Screen Shot 2020-04-11 at 10.36.43 AM.png

61
61 votes

Planned · Last Updated

This feature has been added to the product roadmap. We might communicate about the ETA via our official product roadmap page: https://community.oracle.com/products/oracleanalytics/kb/articles/32-product-roadmaps

«134

Comments

  • Lakshmi Sampath-Oracle
    Lakshmi Sampath-Oracle Rank 4 - Community Specialist

    This will be extremely helpful especially with executive demos. Thank you!

  • Jay Griffeth
    Jay Griffeth Rank 6 - Analytics Lead

    I would love to see this feature as well.

  • Matti Parkkonen
    Matti Parkkonen Rank 2 - Community Beginner

    Have a predefined list of values instead of have to select them one by one in sometimes needed. 

  • gmigotto
    gmigotto Rank 4 - Community Specialist

    It would definitely match an usual need customers have (and are used to with other tools), to filter based on an external list of items.

  • user11940043
    user11940043 Rank 1 - Community Starter

    This feature is extremely helpful to paste multiple values

  • Shrey Tandon
    Shrey Tandon Rank 4 - Community Specialist

    This feature would be very useful for DV users.

  • Marcelo Finkielsztein
    Marcelo Finkielsztein Rank 6 - Analytics Lead

    Suggestion for work around: use an Expression Filter.

    Country IN ('Argentina', 'Armenia', 'Australia')

    caveat: your users will need to learn the correct syntax. Single quotes, parenthesis, etc.

    HTH?

    Marcelo

  • Shrey Tandon
    Shrey Tandon Rank 4 - Community Specialist

    Thanks - great workaround!

  • Branden Pavol
    Branden Pavol Rank 6 - Analytics Lead

    This is probably not an approved solution by Oracle since they are trying to get rid of OBIEE (Classic) dashboards but I have gone with a hybrid approach. I create my DV report and put each canvas as a page on a classic dashboard. I then create a classic dashboard prompt using the same dataset and also put that on the dashboard. That allows you to be able to filter the DV report with the same functionality of classic style. You get the paste list of values option again and you also get to create saved customizations again. A little more work but gives my users the same dashboard experience with some of the enhanced features that DV brings.

  • Marcelo Finkielsztein
    Marcelo Finkielsztein Rank 6 - Analytics Lead

    Hello @Branden Pavol ,

    Do we know this for a fact? ("...they are trying to get rid of OBIEE (Classic) dashboards..."). I have been trying to get an official answer from Oracle about that, without luck so far. Could you please provide a reference to that?

    TIA!

    I will admit my Google-Fu is not strong enough. Shame on me.