Universe Objects Values -- Capital Letters

[Former Member]

Hi all,

I want all universe level (Characters) objects values should be Capital letters before going to report .

Please help me out..

thanks

reddeppa k

[Former Member · Accepted solution]

Please note that ucase is BO specific function. So it works with any database connection. Rest all functions depends on database.

[Former Member · Accepted solution]

sorry , i missed actual point .. i don't want use UPPER functions.

i want all character values should be upper case for particular universe..

Thanks

Reddeppa K

[Former Member · Accepted solution]

What do you mean that? Do you need to set upper case for the data of a particualr universe? We cannot set using direct options. Probably you could use SDK.

But still I am not clear what actually you are looking for.

[Former Member · Accepted solution]

I dont think so you can do it. You have to maulay change or add Uper case funtion in each and every object.

You can check if there ant parameter avilable in PRM file.

[Former Member · Accepted solution]

Hi Gowtham..

In universe we have lot of dimension objects with character .. i want values of dimension should be UPPER CASE.

let example country object values should be like INDIA<,CHINA, AMERICA....

i want make all dimension like this but not uing UPPER function inddudivly..

is there any parameter to set for all ?

[Former Member · Accepted solution]

No We cannot do that unless we use SDK ( hope it can be done using sdk).

There is no parameter also available in universe parameter options.

We must use Upper case function for each object.

Regards

Gowtham.

[Former Member · Accepted solution]

There isn't a parameter, but you could use this utility to change then:

http://www.forumtopics.com/busobj/viewtopic.php?t=21029

Use the Proper(text) function to convert your object names then reapply them to the universe.

Regards,

Mark

[Former Member]

What is the source system for your universe?

It might be easier to make changes there, like creating a view on top of the table.

Regards,

Madhur

[Former Member]

You can User UpperCase(Object) function in the universe.

Hope this solve you problem.

[Former Member]

YOu could probably use ucase function in object definition whichever objects required to be in capital case.