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 ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.