Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

copy/paste mulitple values for a parameter

Received Response
92
Views
11
Comments
deahayes
deahayes Rank 4 - Community Specialist
edited Aug 13, 2024 6:12PM in Oracle Analytics Cloud and Server

Hello all,

Is it possible for a user to copy and paste his choices for a parameter that allows multiple selections, instead of selecting them from the parameter search window.

«1

Answers

  • Shams Abbasi
    Shams Abbasi Rank 5 - Community Champion

    When you say parameter, do you mean dashboard prompt?

  • deahayes
    deahayes Rank 4 - Community Specialist

    yes, dashboard prompt for BI Publisher Enterprise

  • deahayes
    deahayes Rank 4 - Community Specialist

    For example if a prompt has a list of over 100 values and user wants to select 50, instead of scrolling and selecting the ones they want, can they copy and paste from a text file?

    pastedImage_0.png

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Hi,

    1. You must check on column prompt: Enable user to Type Values.

    2. Then user can past on prompt something like that: BROKER;CATALOG DISTRIBUTOR;DYSTRYBUTOR;INDEPENDENT;

    every values with semicolons as example.

    value1;value2;value3;...;

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    ^-- +1 to this. Just don't come back and complain about non-valid strings pasted from Notepad. It doesn't auto-correct...

  • Chris Arnold
    Chris Arnold Rank 5 - Community Champion

    Additionally, you could also...

    (1) Click the 'dropdown' arrow of your prompt

    (2) Your list of values pops up. At the bottom of the list, you should see 'Search'. Click on that.

    (3) That brings up the 'Select Values' box. Look at the very top-right corner of this box and you should see a little pencil. Click on that pencil.

    (4) That brings up the 'Edit' box.

    (5) In this 'Edit' box you can past values

    edit_box.jpg

  • deahayes
    deahayes Rank 4 - Community Specialist

    thanks, this is what Im looking for but I don't have a pencil in the right hand corner. How do I enable it?

    pastedImage_0.png

  • deahayes
    deahayes Rank 4 - Community Specialist

    thanks choracy69, where can I find Enable user to Type Values?

  • Chris Arnold
    Chris Arnold Rank 5 - Community Champion

    I think you probably have your User Input set to 'List Box' or something similar?

    Try setting it to 'Choice List' & see if that gives you the 'pencil' as well as the option to 'Enable user to Type Values'.

  • deahayes
    deahayes Rank 4 - Community Specialist

    Hmmm, I think  were using two different versions. (Oracle BI Publisher 12.2.1.0.0 ) I am not seeing those options under parameters or list of values

    Parameters: parameter type has 3 options (text, date, menu)

    pastedImage_0.png