Using abbreviations for axis labels

Question

Hello,

I am preparing a bar graph showing performance across different master's programs. The program names are quite long and hence I would like to use their abbreviations as labels. The data table doesn't have a column for abbreviated names. Is their a way to use abbreviations as axis labels?

I am using 12c version.

Thanks!

Swati

Jerry Casey · Answer

You can create a new column or revise the column in question using various string functions.

Thomas Dodds · Answer

Use of information drives data design ... you should be storing the vetted and approved short forms in the the Data Warehouse if the source system doesn't have capability for it.

Make an honest attempt to get it implemented there - then you'll have consistency across any/all systems sourcing from the DW.

If not there then do it in the RPD (BI layer) - then those short forms are at least common across your OBIEE information layer.

Don't do it ever in the front end.