How To Reverse the Signs in Transformations

Some times, to be in sink with your reporting requirements you need to change some Negative values(Eg: -100.00) to Positve values(Eg: 100.00) and some Positive values(Eg: 100.00) to Negative(Eg:-100.00).

Here I m giving an example of how simple you can transform all your positive values into negative values using BW Formulas.

BW Formula option is available in both Transfer Rules and Update Rules.

Example:

I want to update data from an ODS to Cube. In ODS I have 0QUANTITY(for Hours). In Cube I have ZHRSBILL(Hours Billed). When loading data from ODS to Cube I want to transform all Hours in ODS into Negative Hours in Cube.

Solution:

- Goto Update Rules between ODS & Cube.

- Select ZHRSBILL Info Object > Choose Formula Option > Create Forumla

- Select NEGATIVE( ) Function from Functions list & Info Object 0QUANTITY from the Fields list.

The final result should look like

NEGATIVE( Quantity )

Save & Activate Update Rules.

-----------------------------------------------------------

Tip:

You can achieve the same result by writing a simple routine in UR's

RESULT = COMM_STRUCTURE-QUANTITY * -1.