Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI report parameter entries - allow manual entries or search a value in the drop-down list

edited Feb 6, 2019 9:52PM in Reporting and Analytics for ERP 14 comments

Summary

Need to allow users to make manual entries or click on the drop-down list to search for a report parameter

Content

All of our BI reports are set up with a drop-down list for each report parameter (Parameter Type = Menu in data model).  Since the drop-down list only displays the first 20 items of company/account numbers, As our segment values are several hundreds, our accountants are forced to click on "Search" to find the already-known company/account number.  This process is very cumbersome and required to be repeated on every parameter entry on each BI report. 

We are able to change the Parameter Type in the data model from "Menu" to "Text".  Now the users can enter the values directly onto the parameter fields.  However, manual entries are also prone for mistakes.  It would be nice if the user entries can be qualified by the system.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!