Impromptu Uppercase Configuration

[dallasfaniac]

Would anyone be able to tell me if there's a way to configure Cognos Impromptu to ignore uppercase for letters?

I have imported some columns such as:
Verified (Y/N)
TP Points

Notice the uppercase letters. When I goto catalog folders and look at the columns I see:
Verified(y/n)
Tp Points

I have so many of these columns, that manually changing each one to uppercase is a real pain. Any help is appreciated, thanks.

 

[SteveFinance]

I'm not sure if this is what you are looking for, but you could create a calculated column of your lowercase column using the function "ucase". You would have something like "ucase(your lowercase column)". Hope that was helpful.

 

[DoubleD]

As far as I know there is no setting within Impromptu to tell the catalog to keep case sensitivity. Everything is converted to proper case.

Pain is stress leaving the body.

DoubleD