In a BW query you are using boolean operators in order to simulate an IF-Opertion for selecting a specific keyfigure.
Example Formula: (VARIABLE == 1) * KYF1 + (VARIABLE == 2) * KYF2 + (VARIABLE == 3) * KYF3 ..
In the result of the formula value MIX (*) is displayed.
The observed behaviour occurs when:
- At least one of the involved keyfigures that are multiplied with 0 contains mixed units/currencies.
- The system is running on BW750 SP04 or higher.
Upgrade, mix, star, currency, unit , KBA , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-OT-OLAP-CUR , Translation of Currencies or Units , BW-BEX-OT-OLAP-UOM , Unit Convertion , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.