Reverse Signs in BPS Layouts

[gregor_kolck]

Dear all,

I'm looking for a way to reverse the signs in BPS Layout.

Storage in Cube:

Costs +

Revenues -

Display and input in BPS-Layout

Costs -

Revenues +

That is it should work somehow like the sign reversal in queries.

I checked the standard function Automatic Sign Assigment

http://help.sap.com/saphelp_sem40bw/helpdata/en/41/0e28c474eb11d4b2fb0050dadfb23f/frameset.htm

but this seems to be diffent.

Any ideas?

Best regards

Gregor

[gregor_kolck]

Gregor,

Thanks for feedback.

I think these are the options.

Gregor

[gregor_dieckmann]

Hi Gregor,

you want to have a 'static' sign reversal (all values multiplied by -1); this does not exist as a planning layout feature. In BPS sign reversal was designed to display both costs and revenue with +.

Also in BW queries there exists a 'static' sign reversal as a property of a structure element and in addition one can use master data attrbute lookups (replacement path variables) and formulas to get a master data value specific sign.

In BPS one can use a planning function to revert the sign before data input and after data input. Depending on the UI you can also use VBA makros to do the sign reversal (Excel-Inplace). In a WebIntefaces you can implement your own exit class; there you can control the data. Maybe the latter solution is not self-explaining.

Regards,

Gregor