Capitalizing the Initial character of a Column’s Data in OBIEE

Standard

Let’s say, your database containing the data in small letters for one of the columns.

Now, requirement is like, need to capitalize the first character of every value in that column.

One approach is: If you are using Oracle database, you can use Initcap function with Evaluate function in obiee. Actually, Initcap function in oracle capitalizes every character which comes after space along with 1st character.

You need to write functionality as shown below, to achieve your requirement.

SyntaxEVALUATE(‘INITCAP(%1)‘, Table.ColumnName)

Ex : EVALUATE(‘INITCAP(%1)‘, Products.”Prod Category”)

If it’s not oracle database, you find equivalent and appropriate function for Initcap for your own database and write the same in Evaluate function

Another Approach is:  Write the following functionality in one column of answers

upper(SUBSTRING(Products.”Prod Subcategory” FROM 1 FOR 1)) || SUBSTRING(Products.”Prod Subcategory” FROM 2)

But this shows only first letter as capital, and remaining all in smaller case.

You can write these functionalities in rpd also… and make use those columns directly in Answers.

You can find my answer in forums for same question here

Hope it’s helpful to you…

Advertisements

2 responses »

  1. INITCAP returns char, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric.

    • Thanks for detail explanation… My intention is just to: show how to use db-functions in OBIEE

      Anyways, thanks for your inputs..!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s