Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Using abbreviations for axis labels

Received Response
11
Views
2
Comments
4cd9b21a-c7d6-4053-a425-c6442eae4eab
4cd9b21a-c7d6-4053-a425-c6442eae4eab Rank 1 - Community Starter

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

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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.

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

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