1 person found this helpful
I just can't get my hands on it anymore (I guess I saw it in a blog post), so can't give you any valid link or hint right now. But there was something like that in 11g and let's be optimistic the same (or similar) will works for 12c.
2.) "12c" since so far we have had 21 (twenty-one) "12c" versions! - ref. MOS Doc ID 2070465.1
3.) Generally sounds like poor design and/or data quality. If it is only numeric then the field should be numeric.
We are using Obiee 188.8.131.52.0 version.
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.
Perhaps in addition to the search functionality have additional Prompts to reduce the employee ID count (region, company, department, function, etc)...
Millions of potential values in a selector for an analytics system is missing the point of the design and intent of the system.