Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How can we restrict a user to write only numbers in the text fields in obiee 12c reports?
How can we restrict a user to write only numbers in the text fields in obiee 12c reports?
Answers
-
What do you mean?
Are you talking about BI Publisher reports? About OBI Answers analysis?
What is a text field in your mind?
0 -
its regarding BI Publisher report
0 -
a) You didn't answer Gianni's other question.
b) With a "problem description" like that you won't get much in terms of usable answers. What do you mean "write only numbers"? Input validation? For what? A prompt?
0 -
force the prompt to be a searchable lookup and selection instead of free-form text ... if you have too many values, then you need additional restricting prompts to narrow down the scope of the final list
example:
if you have 600,00 customers maybe you need a City prompt to narrow the search down to 100,000 then you need an additional one to maybe filter by ZIP Code and now you get 30-50,000 in a zip code and then maybe filtering those by sales rep to get the 10-15 to pick from...
free-form is ungoverned (free of any form)...
0 -
And, to keep it simple - i have an Employee ID prompt - which is text field prompt.
I cannot use drop down or choice list as i have millions of employees.
And, employee id values in database are numeric. (which is good)
However, we have few users - who may enter some string values unknowingly in the text field prompt.
Can we have integrate any customization - so, that when users enter any characters other than numeric it should say - enter only numeric values.
0 -
My solution to this is to set a presentation variable in the employee ID prompt, say "varID".
Then, in the filter of the query, insert: UPPER('@{varID}')=LOWER('@{varID}').
In the 'No Results' view, type the custom message "Invalid Employee ID - Numbers Only!"This only works as a test for unwanted alpha characters, (and maybe only in English?)
0
