Is there Ignore case function in BO?

building semantic layer
1

Hi,
In the webi report,if we want to allow the users to enter the values in any case through prompt,how can we achieve that?
Because,if user enters a value in upper case(or some letters in upper case and some letters in lower case) and in database the value is stored in lower case then the report will return zero records for the same.
So, is there any function in BO to ignore the case ?

Thanks in advance. :slight_smile:

mswap :india: (BOB member since 2009-12-10)

2

hi,

And welcome to B:mrgreen:B

Force your string to lowercase :slight_smile:

=Lower([string])

And THIS document can be a good help :wink:

Regards,
-John Vincent

jvmauricio :philippines: (BOB member since 2009-08-03)

3

Welcome to B:bob:B! I believe your question is universe based and not the reporting one. What is your underlying database? Shall I move it to the Universe Designer forum?

Jansi :india: (BOB member since 2008-05-12)

4

Hi John,
Thanks for a warm welcome and quick reply!!
Can you please tell me where should I apply this Lower([string]) function,coz I want to force the string entered by the user (In the prompt)to lower case,so that it should match the values of the database.

Hi Jansi,
Thanks for the welcome!!
My database is Oracle and I am not sure where to apply the function,so I am not sure if we should move this to the Universe designer forum.

mswap :india: (BOB member since 2009-12-10)

5

Apply it in the universe and use the relevant oracle function.

Damocles :uk: (BOB member since 2006-10-05)

6

[Moderator Note: Moved to Semantic Layer / Universe Designer - Jansi]

Jansi :india: (BOB member since 2008-05-12)