Change Legend Names in OBIEE

Question

Hi,

I have a column in DB: LOB which contains the following values as displayed:

When I Plot a graph using LOB as legend, displaying such big values consume a lot of space, which is often confusing. Is there any way to display the short names like UK and CE for UK and CE Financial Services and so on, so that my graph is more readable? My requirement is to only display the short names in legend. Help is highly appreciated.

Gianni Ceresa · Answer

You need to not double post! How to change the column value names in OBIEE

It's against the ODC forum rules (maybe worth a refresh) and you got your answers in the other thread.

So go back there, mark as required if you got the answer or just ask more details of you don't get what the replies means. The answer is there (it really is).

PS: you do not seem familiar with the concept of "mark as correct" an answer so the thread is flagged as answered and it can actually benefit other users having the same question. Not answered threads (so missing a formal "correct" answer identified as such) aren't helpful as other users have no idea if what is posted is actually an answer or not and need to read the full thread. That's not the idea of a community forum where you take & give.

Thomas Dodds · Answer

Again - you need a lookup/translation table ... USE drives DESIGN.  Store your data in it's usable format.

Robert Angel · Answer

Hi,

you need to define "short" before anyone can answer that.

if 'short' is a user intelligent abbreviation of the current content then you have to have a manual exercise to explicitly populate exactly what you need in the DB, then you need to model the column through OBIEE if it is not already there, or use a lookup table to achieve similar. Then put it in your answers report.

If it is first 'X' characters, to (say) the first space or end of string then you could achieve it with nested formulas in answers.