Thank you

Sir, We are using Obiee 12.2.1.3.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…