Presentation on SAP BW 7.2 : New features

Check this out a good presentation from SAP on what's New in SAP BW 7.2

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0ea8b43-26af-2c10-f1b5-bbb69060de87?QuickLink=index&overridelayout=true


Enjoy !!!

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

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...