Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE - Adding a dynamic currency symbol to table values

Received Response
11
Views
2
Comments
OracleUser_MUC6U
OracleUser_MUC6U Rank 5 - Community Champion
edited Aug 13, 2024 6:10PM in Oracle Analytics Cloud and Server

Hi,

I have a currency dropdown on my dashboard and a table showing Gross Revenue metric for a specific currency.  I have a requirement to add the currency symbol to each G.R. value in the table.  To do this I've set a presentation variable(p_curr_symbol) on the currency dropdown and appended the presentation variable to the G.R. column like so '@{p_curr_symbol}{$}'||CAST("Fact"."Gross Revenue" AS CHAR). This works well until I apply column sorting. Since the column is now a char the sorting will order the values reading from left to right, so asc sorting will order value 123 before 23.

Anyone had a similar requirement and has been able to resolve the sorting?

Thanks.

Answers

  • Pedro F
    Pedro F Rank 6 - Analytics Lead

    Hi,

    I don't you just add the original Gross Revenue metric to the analysis as well, add a sort to that column and in the column properties hide this column (checkbox). That way, you can add this column to your table and the sort will be applied.

  • OracleUser_MUC6U
    OracleUser_MUC6U Rank 5 - Community Champion

    Thanks Pedro.

    We need to allow the user to sort asc/desc on any column in the table including the G.R. column with currency symbol.