Is there a way to add a currency ($) symbol to the graph of OBIEE? — Oracle Analytics

Oracle Analytics Cloud and Server

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

Is there a way to add a currency ($) symbol to the graph of OBIEE?

Received Response
31
Views
3
Comments
kevinsun91
kevinsun91 Rank 1 - Community Starter

Hello,

I am using Oracle OBIEE 11.1.1.7 and I have a graph that displays multiple lines (each line tracks different budgets). The x-axis is time (in months) and the y-axis is the amount in dollars ($).

I have already changed my variables to currency by editing column properties -> data format -> Treat Numbers as Currency.

However, whenever I hover over a data point in the graph, it shows the numeric number instead of a dollar amount with the dollar sign($) in front of it. Why is this happening and how can I fix it? Thanks!

P.S. The table shows the dollar signs correctly, I just can't get the graph to show the dollar signs.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Works in 11.1.1.9.x and 12.2.1.0.0. Don't have any old 11.1.1.7.x anymore.

    Edit: Meh just realized you can't see the hover-over text in the screenshots. Redoing...

    pastedImage_0.png

    pastedImage_1.png

  • Pedro F
    Pedro F Rank 6 - Analytics Lead

    If you edited the column properties it should display fine in the graph. However, if it doesn't, you can also go to Edit graph properties -> Titles and Labels -> Formatting of data markers -> Number Format and set the currency symbol there as well, it should do the trick.

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Hi,

    I work on OBIEE 11.1.1.7.131017 and it's working fine both on table and graph.

    pastedImage_0.png

    And on the Bar Graph:

    pastedImage_2.png

    Or in Line Graph:

    pastedImage_3.png

    Maybe, try again to perform this operation.