SAP Knowledge Base Article - Preview

2448651 - BW750 - Boolean operators with mixed units/currencies


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:

  1. At least one of the involved keyfigures that are multiplied with 0 contains mixed units/currencies.
  2. The system is running on BW750 SP04 or higher.



SAP NetWeaver 7.5


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 page

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