Oracle Communities

Oracle Analytics and AI

Child Item

BIP Options

Content

Hi experts - I need some assistance with some options within BI Publisher reporting, hoping you can help!

1) Is it possible to allow users to type into a parameter field their choices, rather than having to choose from a drop down menu? It appears that with the menu option selected, users can select multiple options, but is it possible for them to paste into that field vs having to sort through the full menu list to find their options. EX: Business Unit = Human Resources;Information Technology. Can I just copy/paste those two choices in?

EDIT: See chosen best answer

2) Is it possible to set the default report output options? Right now, I see that the default is always Interactive; HTML; RTF; PDF; Excel (*.xlsx); PowerPoint (*.pptx). I would like to change those defaults but cannot find where to do that. I know I can do it at the report level, but I have to change it every single time I create a report, and I'd like to change that.

EDIT: Appears there is no global setting for this

Thank you all!

EDIT 17MAY2018: As I asked two questions, updated with answers for others to view

Find more posts tagged with

BI Publisher

BI Publisher Data Models

Accepted answers

All comments

Prudence K

Thank you! I updated my post to ensure that I captured the answers as I saw your post too late to mark for best answer. I appreciate your knowledge!!

Isaline Nguyen

Hello all,

You seem like you could possibly help me solve one of my menu dropdown issues as well:

My dropdown menu is a list of valuation units, but I also need the option ALL, so that all of them would be taken into account when needed.

ALL is not a real value among the valuation units.

How can I alter the menu so that it would capture the whole list, or what would be the best way to edit the query?

Thank you,

Regards,

Isaline