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

Ho can we change the display type in a column in OBIEE to "change sign"?

Received Response
3
Views
5
Comments
1467551
1467551 Rank 1 - Community Starter
edited Aug 13, 2024 7:09PM in Oracle Analytics Cloud and Server

We want to generate an income statement in OBIEE

Is there a way, like in Oracle eBS FSG's, to "change sign" to display data in a row/ column? We only want to change the way a particular row/ column DISPLAYS data without changing the underlying data itself. 

This is to show Revenue account balances as positive number (with credit balances)?

Thanks!

Answers

  • 3055888
    3055888 Rank 1 - Community Starter

    Edit Formula and use Case When Statement will enable you to change the sign based on Account Range

  • RichardChan
    RichardChan Rank 6 - Analytics Lead

    You can create a new column Y in the BMM layer based on the incoming field X.

    The formula to change the sign would be 0 - X, you can then expose this column in the presentation layer.

    If you always want a +ve value then you can use ABS(X)

    Mark Answered if this has helped

    Richard

    NeoData Australia

  • 1467551
    1467551 Rank 1 - Community Starter

    Thanks, Richard.

    Building on your answer - on the income statement data column we have revenue and expense amounts - how would we only have the *rows* with revenue data displaying the data as positive number?

    Can this BMM layer manipulation work on rows as well?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Do what @3055888 said: a CASE WHEN <account columns> = 'Revenue' THEN <your fact> * -1 ELSE <your fact> END

    Of course all the options posted works: 0 - x, x * -1, ABS(x)

    You are supposed to have a dimension or an attribute somewhere allowing you to identify your revenues to use as condition in the CASE WHEN.

  • RichardChan
    RichardChan Rank 6 - Analytics Lead

    You can also use ABS and 0 - measure in the column formula

    Richard Chan

    Neodata Australia

    Sent from my iPhone