5 Replies Latest reply on Jan 22, 2016 10:59 PM by RichardChan

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

1467551 Jan 21, 2016 4:53 PM

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!

1. Re: Ho can we change the display type in a column in OBIEE to "change sign"?

3055888 Jan 21, 2016 8:52 PM (in response to 1467551)

Edit Formula and use Case When Statement will enable you to change the sign based on Account Range
Like Show 0 Likes(0)

Actions
2. Re: Ho can we change the display type in a column in OBIEE to "change sign"?

RichardChan Jan 22, 2016 12:29 AM (in response to 1467551)

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
1 person found this helpful
Like Show 0 Likes(0)

Actions
3. Re: Ho can we change the display type in a column in OBIEE to "change sign"?

1467551 Jan 22, 2016 6:44 PM (in response to RichardChan)

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?
Like Show 0 Likes(0)

Actions
4. Re: Ho can we change the display type in a column in OBIEE to "change sign"?

Gianni Ceresa Jan 22, 2016 9:35 PM (in response to 1467551)

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.
Like Show 0 Likes(0)

Actions
5. Re: Ho can we change the display type in a column in OBIEE to "change sign"?

RichardChan Jan 22, 2016 10:59 PM (in response to 1467551)

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

Richard Chan
Neodata Australia

Sent from my iPhone
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.