Skip to Content
Former Member
Nov 18, 2008 at 01:33 PM

BI-IP Input Ready Query Sign Attribute


Hello Experts,

I have an input ready query. In this query a chracteristic (lets say chracteristic-A) is in the rows. And this chracteristic-A has 0sign_rev as an attribute. I want to change the sign of entered values according to the values of the 0sign_rev in the master data table of characteristic-A.

In the SEM-BPS manuel planning layouts there is sign attribute entry area which we can use for this particular problem. In Bex Analyzer i tried to use the reverse sign option but it is not doing the same thing as it is in the BPS application.

As a solution now i am using two key figures. One stores the initial values that users enter, the other stores the values that is changed by an planning funtion according to the 0sign_rev values of characteristic-A. But this temporary solution is getting troublesome while using hierarchies and so forth.

Is there any way of using the characteristic attribute to determine the sign of the entered value with Bex Input Ready Queries?

I thank you very much in advance.