Text field in obiee 12c

Rookie_86

Hello all,

I have a new dashboard prompt with few columns.

Obiee Environment: 12c

And, one among them has user input field as - Text field.

And, others columns are using - choice list, radio button, slider etc..

As per my requirement - users need to only enter numbers in the text field prompt.

It shouldn't enter users to allow text characters ?

Is it possible to acheive.  If yes, can you please share your inputs ?

Thanks.

Gianni Ceresa

Hi,

I'm quite sure in 11g there is a javascript file where you can write validation for prompts etc.

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.

[Deleted User]

1.)

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.

Rookie_86

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 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.

Thanks.

[Deleted User]

Personally I'd rather teach them how to use a search box, but that's just me...

Good luck with your JS

Rookie_86

Thank you

Thomas Dodds

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.