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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.