Dec 18, 2009

Using If-Then-Else in Bex

Conditional Calculations (IF-THEN-ELSE)

You can make conditional calculations using Boolean operators An expression in the form
IF THEN ELSE can also be made using a formula in the form
* + NOT *

Example: IF Actual Costs > Plan Costs THEN Plan Costs + Plan Deviation ELSE Actual Costs

can be written as the following formula:

(Actual Costs > Plan Costs)* (Plan Costs + Plan Deviation) + (NOT (Actual Costs > Plan Costs)) * Actual Costs

or

(Actual Costs > Plan Costs)* (Plan Costs + Plan Deviation) + (Actual Costs <= Plan Costs) * Actual Costs

Dec 2, 2009

SAP Notes that are helpful....for BI

SAP Notes

# 192658 - Setting parameters for BW systems (New Implementations)
# 79483 - MM-IM: Creating the moving average price.
# 185961 - Moving Average Price Calculation



Will be added once in a while...